Needless to say, it is very cool!
http://qlikviewcookbook.com/download/document-analyzer/
Filed under: Uncategorized | Tagged: Qlikview | Leave a comment »
#Qlikview I know I know, it took me forever to try the document analyzer
Posted on May 19, 2015 by mellerbeck
Qlikview resetting variables during reload, solution
Posted on February 5, 2015 by mellerbeck
From http://community.qlik.com/thread/39123
Re: Preventing variable reset on reload
Hi,
I have come across a possible workaround that is working in my environment.
In the document properties/variables tab, for each of the user variables i have ticked the box for “Include in Bookmarks”. After several document reloads using publisher the variable values are being retained after each refresh. I was having a similar issue with Date variables changing back to defaults and now it appears fixed.
Note: You need to reload it a first time, then change your variables and reload again to see the changes is working.
Cheers!
Spud
Filed under: Qlikview | Tagged: qlik, Qlikview | Leave a comment »
our #Qlikview 11 upgrade
Posted on October 1, 2013 by mellerbeck
So I had the fun task of upgrading our server from 11 to 11.2. Usually this is pretty easy next, next, done. (Qlikview has great compatibility across version, they are top notch) this time was a little different because I wanted to upgrade and change over to a new box. (An IBM 3690 X5 196 GB of RAM!) so I messed around a lot and finally found out how to transfer the tasks. This was my step by step.
Pre-steps. Make screen shots of all the config on the old box, copy over private and public folders to new qlikview server (I should have used robocopy to preserve the file permissions! I did not and of course that means until a refresh some of qvw’s had incorrect permissions (because qlikview will just publish anything in the public folder!). Make a copy of the QVPR folder located @ C:\ProgramData\QlikTech\ManagementService\QVPR (this is the magic, this folder has all your tasks)
Unplug the old qlikview box from the network (can plug it back in if things go south)
Change IP and rename new box to the old box’s name. (reboot, of course)
Install Qlikview, turn on the management service so that the QVPR folder will be created and then overwrite it with my QVPR from the old server. Reboot
Go to each screen and put in my settings. Tada
scratch my head why admins can’t get to admin console, google it, remember I need to add the to the local Qlikview admin group.
Filed under: Uncategorized | Tagged: Qlikview | Leave a comment »
How I’ve been #Qlikview ing lately, update
Posted on March 1, 2013 by mellerbeck
So in addition to the below
https://michaelellerbeck.com/2012/09/13/how-ive-been-qlikviewing-lately-qlikview/
And I also started using subversion for source control
https://michaelellerbeck.com/2013/02/19/source-control-subversion-with-qlikview-11-2/
I also like to make a simple little deploy .bat file. This guy copies over my changes, and then runs an EDX command (setup your reload with an EDX task) This way I can check my changes on the server.
Basically:
xcopy “C:\Working_Qlikview\Financial Statement New.qvw” “\\qlikview\c$\Qlikview\QlikView Storage\Private Data\Source Documents\In Production\Accounting\Stuff.qvw”
@ECHO OFF
ECHO Please Wait While Data Refreshes
\\qlikview\QMSEDX_CommandLine\qmsedx -task=”Distribute Stuff” -qms=http://qlikview:4799/QMS/Service -password=apassword
Filed under: Qlikview | Tagged: Qlikview | Leave a comment »
Some #Mobile #Qlikview Designs
Posted on February 25, 2013 by mellerbeck
So I have been working on setting up some scorecarding and dashboarding Qlikviews for display on iphone/ipads. One design tip: design it to be readable on an iphone and it will look perfect on an iPad.
So for lack of a better name I call the top of our “BI” pyramid the scorecard. This is simply a rolled up grade of some metrics.
It looks like this:
If something concerns you (or you want to know more, you simply press say the Bookings KPI) and that will open up the Bookings KPI Dashboard. I did this with an ‘Open URL’ Action and the use the
‘AJAX’ link to the qlikview http://qlikview.nffc.local/QvAJAXZfc/opendoc.htm?document=Sales/BookingsKPI/BookingsKPI.qvw&host=QVS@qlikview
Now, if you want even more specific information you can drill down by pressing the ‘To Bookings By Commodity”
This opens up the Bookings Commodity Dashboard
It looks like this
Notice buttons down the right (better ipad/iphone UI)
I use list boxes because this allows for single click (instead of click and hold which I find an annoying interface most the time) for charts I will overlay a listbox to accomplish this.
Filed under: Qlikview | Tagged: Qlikview, scorecarding | Leave a comment »
Initial Selection with Ajax and Qlikview
Posted on January 29, 2013 by mellerbeck
Often times especially with mobile qlikviews you want to set an initial selection. Unfortunately the OnOpen trigger is not supported with AJAX mode (which is the best way of accessing qlikviews with a mobile device)
How to best do this then?
Well at first I tried creating a bookmark and then saving the doc with that bookmark applied. Actually its interesting to use a search string to apply a variable as a bookmark. The Syntax looks something like =gl_perod_year=$(vCurrentPeriodYear)
Assuming you have Variable set with the right year data
Unfortunately this didn’t work. So I ended up using the OnOpen Trigger. Apparently, at the moment at least, if you apply a bookmark using an OnOpen trigger it seems to work well with the AJAX version. Go figure.
So, find out your bookmark ID and use that with an Apply Bookmark action
Clear as mud?
http://community.qlikview.com/message/301451#301451
Filed under: Qlikview | Tagged: ajax, qlikvie, Qlikview | Leave a comment »
Some methods of Learning #Qlikview
Posted on November 12, 2012 by mellerbeck
I’m always looking for ways to increase my knowledge about Qlikview. I really wish someone would write a 1,000 monster Bible on the product but Alas I haven’t found it yet.
Some things I have found:
Books on Qlikview: Hello Qlikview This is a nice little intro guide to qlikview, this is good to hand to someone who is just starting to get into self service BI using Qlikview.
Qlikview for Enterprises This is a very indepth book about BI, ETL, and practices surrounding an Qlikview implementation. It won’t really help you learn how to script / or design though.
Qlikview 11 Developers Guide This book isn’t released yet (as of 10/9/2012) it looks like it should be pretty good
—
The next thing that I find very useful is to follow people on the Qlikview Forum and read everything that they post 🙂
For scripting awesomeness you should follow
Henric Cronström and Rob Wunderlich
Speaking of Henric (I wish he would write a book on Qlikview!) you should read all of his Tech documents
http://community.qlikview.com/people/hic?view=documents I really like
http://community.qlikview.com/docs/DOC-3102
http://community.qlikview.com/docs/DOC-3155
http://community.qlikview.com/docs/DOC-3412
http://community.qlikview.com/docs/DOC-3451
And speaking of Rob you should check out his downloads http://robwunderlich.com/downloads/ he has the awesome Qlikview CookBook as well as the Qlikview Components
http://code.google.com/p/qlikview-components/
—
I also like to follow Steve Dark all of the qlikviews he publishes are extremely well done and documented.
—
So, I also like to follow a bunch of Qlikview Blogs.
If you are interested in making Qlikview look Awesome you really need to read everything by http://qvdesign.wordpress.com/
I also like http://fortunecookiebi.blogspot.com/
http://livingqlikview.blogspot.com/
http://mindspank.wordpress.com/
http://oneqlikatatime.blogspot.com/
http://www.quickintelligence.co.uk/
http://qlikviewnotes.blogspot.com/
http://www.qlikviewaddict.com/
Filed under: Qlikview | Tagged: awesomeness, Qlikview | Leave a comment »
