topic Re: Calculate sum for previous dimension value in QlikView

Calculate sum for previous dimension value

lsdrolias — Tue, 23 Jul 2013 12:39:30 GMT

Hi,

I have a pivot table where I sum a numeric field by a date field:

dimension field: pdate

expression: sum(stockqty)

I now want to add another expression to sum stockqty for the previous date. How can I do that with set analysis?

Thanks for your help

Gysbert_Wassenaar — Tue, 23 Jul 2013 12:51:45 GMT

You can't with set analysis. The set is calculated per chart, not per row. Try above(sum(stockqty))

swuehl — Tue, 23 Jul 2013 12:52:29 GMT

You should look into the chart inter record functions, namely above() or before() [depending on your table layout]:

=above(sum(stockqty))

=before(sum(stockqty))

lsdrolias — Tue, 23 Jul 2013 12:57:43 GMT

Thanks for the reply. Unfortunately, above(sum(stockqty)) does not produce any value

lsdrolias — Tue, 23 Jul 2013 12:57:56 GMT

Thanks for the reply. Unfortunately, above(sum(stockqty)) does not produce any value

lsdrolias — Tue, 23 Jul 2013 12:58:45 GMT

Thanks for the reply. Unfortunately, teh expression above(sum(stockqty)) does not produce any value

lsdrolias — Tue, 23 Jul 2013 12:59:00 GMT

Thanks for the reply. Unfortunately, the expression above(sum(stockqty)) does not produce any value

lsdrolias — Tue, 23 Jul 2013 13:04:36 GMT

Thanks for the reply. Unfortunately, the expression above(sum(stockqty)) does not produce any value

lsdrolias — Tue, 23 Jul 2013 13:25:26 GMT

Sorry for the multiple replies. Yes, the above function solved my problem. Thanks.