Advertisements

How to transfer state using the IE Qlikview Plugin, solved

Posted on February 24, 2016 by mellerbeck

I’ve been slacking a bit on my blogging 🙂

After some trial and error I was able to transfer state from one Qlikview to another using the IE plugin on the Qlikview server.

The first thing to figure out is the path to your Target Qlikview.

The easiest way to do this is to open up the qlikview on the portal and then press Control + Shift + Q (Or go to the menu of the Qlikview plugin and choose Document Support Info)

transfer state

Copy that address. I’m not sure why it uses the qvp protocol, but hey this works.

Ok, now on your starting Qlikview you need to have a field that matches exactly a field in your target Qlikview. Otherwise it won’t work

So create a button, choose ‘Open QlikView Document’ paste in the URL you got from before (You can remove the qvp://qlikviewservername/ if you want)open

Click Transfer State.

Now publish your starting Qlikview (the button won’t work from Qlikview desktop)

And press the button. If everything works correctly you should see selections passed from one Qlikview to the Next. (If no selections are possible on the target, nothing will happen)

Advertisements

Filed under: Qlikview, Uncategorized | Leave a comment »

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
Ryan O'SullivanApprentice

Ryan O’Sullivan Dec 29, 2014 12:13 AM (in response to connextions1)

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: , | Leave a comment »

#Qlikview QlikTech Open Data Challenge, Do you Realize

Posted on March 3, 2014 by mellerbeck

So Qlikview recently ran a ‘Take Action Open Data Challenge’, basically use Qlikview on public data to uncover unexpected insights to positively change the world.

The 1st Place winner was ‘Do you Realize’ created by Alexandre Perrot, and Software Advice wrote a post on how he goes about developing dashboards.

The first point is to Think about the data. This is a great reminder, thinking through a problem can often times save you a lot of time later.

The author recommends a snow flake schema, this is pretty typical Qlikview recommendation.

He then next thinks about what the user is going to click and interact with. He started out with an overview screen.

This qlikview is very much an example of information storytelling, something Donald Farmer would no doubt approve of.

do you realize

Clicking on Start tests your knowledge of what potentially will occur as far as population growth and environmental changes. It scores you as you move through it. Clicking on the leaf or the heart on the side takes you to the Environment or Health pages. Clicking on the word ‘environment’ or ‘health’ takes you no where, I would assume those button-like objects would take you there as well. Slightly annoying.

As you move through the quiz you are given the opportunity to learn more, which will take you to the salient detail screen… continuing your knowledge foraging. I did wish that I could click back to where I was in the quiz instead of having to restart each time though.

After the Overview screen he advises to create screens that help a user understand a given KPI.

He advises using color to convey change. I agree completely… but in this case I think too much color and too much chart junk is used. http://www.perceptualedge.com/articles/visual_business_intelligence/rules_for_using_color.pdf

envir

I find the use of color a little overwhelming. I would remove the ‘blue haze’ behind the map. I do like the map it is very visually appealing. I’m not a big fan of the pie chart, neither do I like bubbly iphone’ish pie charts.

Overall I agree with the points laid out by the post. I would recommend a simpler approach, but that just my 2 cents.

Filed under: Qlikview | Leave a comment »

#Qlikview Responsibility Box

Posted on April 24, 2013 by mellerbeck

So this is a simple idea so that users know who to go to with questions about specific Qlikview i.e. who is the ‘SHMEEEE ‘

So use a variable in the load script

vDocOwner = ‘youremailaddress@somewhere.com’

Now create a text object displaying the vDocOwner

If you want to be extra fancy (For extra fancy you can even include the name of the document in the subject…. & subject=)

In its properties, on “Action” tab, choose : “Open URL”

In the command line, write :

mailto:noone@nowhere.com

Now if they click on they can send the responsible party an email….

There, enjoy extra responsibility responsibly

responsiblity

 

 

Also, I should make a link to a wiki page that describes the Qlikview but I will save that for later.

Filed under: Qlikview | Leave a comment »

#Qlikview rules of thumb

Posted on April 23, 2013 by mellerbeck

This is a short list but will continue to add more. These are mainly coming from the Qlikview masters summit

Declare all variables in the script (Especially important if you use source control)

Drop the seconds from DateTimeStamps if not needed (probably not needed most of the time)  I’ve been using cast(TheDate as Smalldatetime) as TheDate as a SQL way of doing it (any better ways??)

IF’s are evil, especially if the execute for every row

Filed under: 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: | 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:

scorecard

 

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

bookings dashboard

 

 

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)

Sales Type COMMODITY customer

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: , | Leave a comment »

Next Page »
Advertisements