topic Re: previous day difference? in QlikView

previous day difference?

Mon, 11 May 2015 05:36:32 GMT

Hi,

I have a pivot table, which have days as one dimension. for each day i have to get a sum(value). in the next column i have to get the difference between the previous day and today. how can i achieve this??

please help..!!

Re: previous day difference?

Anonymous — Mon, 11 May 2015 05:38:36 GMT

Hi,

Try using above function

sum(value) - above(sum(value))

Regards,

Greeshma

Re: previous day difference?

Mon, 11 May 2015 05:45:20 GMT

Hi..

thanks for your Reply...

can i get the same in script??

Re: previous day difference?

Mon, 11 May 2015 05:48:12 GMT

you can use

today()-previous(today()) to achieve the same in script.

Amay

Re: previous day difference?

Anonymous — Mon, 11 May 2015 05:48:31 GMT

Hi,

In the script you will have to use previous function.

Regards,

Greeshma

Re: previous day difference?

tresB — Mon, 11 May 2015 05:49:49 GMT

Yes, you can. You have to use Previous() or Peek().

Re: previous day difference?

jonathandienst — Mon, 11 May 2015 05:49:56 GMT

You can, but that is not what you asked in your original post.

LOAD ....

Sum(Value) - Previous(Sum(Value)) As Difference,

...

FROM ...

Group By <all other fields>

Order By <the relevant sort sorder>

Post a sample qvw and sample source data (text file or Xls) for more specific and detailed help.