topic Chart animation based on variable in QlikView

Chart animation based on variable

RSvebeck — Thu, 09 Feb 2012 08:18:15 GMT

I have a scatter chart with one dimension and three different expressions (x,y and size), and all of the expressions has a factor based on a variable that I have as a slider below the chart (it’s a percentage factor from 50% to 200%)

I would like the scatter chart to be animated based on my variable. Like if I was sliding the variable from it’s minimum 50% to it’s maximum 200%.

The variable is not a dimension and it seems like animations can only be based on dimensions.

Perhaps animations is not the right approach, but I want to visualize what is happening to the data when the percentage factor increases from 50% to 200%, it’s the change/movement I’m after not the actual positions.

What can I do?

Regards

Robert

Re: Chart animation based on variable

kaushiknsolanki — Thu, 09 Feb 2012 08:25:07 GMT

Hi,

If you just want your scatter chart to be changed when the slider value changes, then its not an animation, we call it as what if analysys.

Find the application attched which shows the what if analysis.

Regards,

Kaushik Solanki

Re: Chart animation based on variable

oxtontom — Thu, 09 Feb 2012 10:30:13 GMT

Hi Robert,

I understand what your trying to say, you want to be able to visualise the transition between data points making the actual change in data positions viewable. As far as I am aware there is no way in Qlik of doing this atm.

You might be able to use this link about timings and variables to make it switch between two version of your chart (the atlered and the original every 5 seconds). So you would place both charts on top of each other and have different show conditions so that it switches between the two depending on the timer.

http://community.qlik.com/message/135906#135906

I know you can use the conditional show on its own rather than a timer variable to allow a chart to "flash" but I can't find the post I am affraid

Obviously this isn't an ideal solution, hopefully someone else can help you!

Thanks

Tom

Chart animation based on variable

RSvebeck — Thu, 09 Feb 2012 12:06:24 GMT

Thanks for replying. However, it's the movement I'm after. I want to be able to answer the question: "On which value of my variable are the circles in the chart moving in the best way." All my circles are following it's own individual path which is not always following a linear function. But my hypothesis is that at one single point, the majority of the circles are moving in an optimized way, and what I want is to find that point if it exists, and if it does not exists then I know that this factor is not relevant for the performance I'm investigating. Regards, Robert

Chart animation based on variable

RSvebeck — Thu, 09 Feb 2012 12:15:33 GMT

Hi Tom. Thanks for the reply, I will look at it and see if the performance is ok. I got one more idea today, and that is to create a calulated fictive dimension with the valuelist() function and use that as the animated dimension, and connect that dimension somehow to my variable.... //Regards Robert

Re: Chart animation based on variable

oxtontom — Wed, 15 Feb 2012 16:55:21 GMT

Hey Robert,

Just wondering if you managed to find a solution to this? also did the fictive dimension idea work?

Thanks

Tom

Chart animation based on variable

RSvebeck — Thu, 16 Feb 2012 07:39:39 GMT

Hi Tom,

I haven't got it to work with the fictive dimension. I cant get the dimension to reflect into my variable, and I can't get my expressions to refer to my ficitivte dimension either.

I have instead started to develop an Extension Object in JScript to solve this, but that will take som time (weeks) since I'm kind of new to extension objects, and there are soo many other things to do as well...

I will post here whenever this turns into a good solution.

//Robert

Chart animation based on variable

RSvebeck — Thu, 16 Feb 2012 08:13:28 GMT

Hi again,

I can also add that I did try this in my variable:

= 1 + (mod(round((now()-now(2))*86400),35))/100

This will give me a count on my variable from 1.01 and up. This also give an "animation effect" on my scatter chart, but the update frequency of 1 second is to slow, and I could not find any function that could give me milliseconds - and I doubt that the chart will be able to update faster sicne with the one second update it flashes for every redraw.

//Robert