topic Plot Change over Time in QlikView

Plot Change over Time

Thu, 27 Aug 2009 22:50:58 GMT

I have a simple line chart that plots sales over time. I need to transform this chart to show the change in sales over time.

The current chart data:

Month - Units
Jan - 10
Feb - 15
Mar - 25
May - 15

What I'm tying to achieve:

Month - Change in Units
Jan - null
Feb - 5
Mar - 10
May - (10)

The easiest solution I can think of is to handle this in the staging database prior to loading or during the load script. However, I prefer to implement the logic in the chart expression.

I'm guessing the solution involves set analysis and or the aggr function. I figured out how to calculate the period over period change using set analysis, but only when the user selects a specific month.

Any help is much appreciated!

Plot Change over Time

Thu, 27 Aug 2009 23:15:57 GMT

See attached example, uses a very simple Above() function in the expression.

Cheers,

Plot Change over Time

Thu, 27 Aug 2009 23:23:40 GMT

Is there any chance you can paste the expression as text on the forum? My company is in the process of purchasing Qlikview, so I'm using the personal edition until we everything is set-up (I can't open external docs).

Thanks,

Peter

Plot Change over Time

Thu, 27 Aug 2009 23:29:00 GMT

Hi Peter

Expression is :

=Sum(Sales) - Above(Sum(Sales))

Hope it helps,