topic combo chart set analysis for the difference between values in QlikView

combo chart set analysis for the difference between values

jasonseril — Fri, 13 Nov 2009 15:54:14 GMT

Hello again,

I have attached a qvw file with combo chart. I would like to add another expression that displays the difference between previous day value. Say, Day 2 - day 1 = 30; day 3 - day 2 = 50 and day 4 - day 3 = -10, plot these values to the chart. What would be the set analysis for this?

thanks in advance.

jason

combo chart set analysis for the difference between values

Fri, 13 Nov 2009 19:55:01 GMT

Hi,

If you want to calculate difference you don't need to use set analysis

Just update the chart expression to =sum(value)-above(value).

Rgds

combo chart set analysis for the difference between values

jasonseril — Fri, 13 Nov 2009 20:35:39 GMT

ok, i got it. thank you very much spartor.

jason