topic Re: Line chart automation in QlikView

Line chart automation

Anonymous — Mon, 26 May 2014 12:58:34 GMT

Good day,

I am trying to create an animation on a line chart.

On the chart I only have one dimension, which is the week numbers and 1 expression which shows the total hours for that week.

If I select 'Animate' and check the box 'Animate first dimension' the chart only shows one symbol per week as the animation runs.

So every week will run through with its value but the graph will not create a trend.

I would like it to draw the line as the animation runs through the week numbers: So when it gets to week 5 we can see the line of week 1-5 on the chart and not only the symbol for week 5 (This is what currently happens).

Please let me know what I need to do to enable this functionality on my chart?

Thanks,

Tiaan

Re: Line chart automation

Mon, 26 May 2014 13:09:24 GMT

like this?

Re: Line chart automation

Anonymous — Mon, 26 May 2014 13:37:37 GMT

Yes Dariusz, that is exactly what I need. Can you please explain to me how you did this?

Re: Line chart automation

Mon, 26 May 2014 13:43:10 GMT

as you can see, i loaded additional dimension (anim_week).

I use 2 dimension (anim_week and week) in chart

So, anim_week is dimension for animation.

My expression is:

sum(if(week<=anim_week,value)).

So, with each animation step anim_week grows up.

And expression is calculated for all weeks which are less or equal to this anim_week.

regards