topic Calculate two dates changes in Pivot table in QlikView

Calculate two dates changes in Pivot table

msmichael — Wed, 05 Dec 2018 19:53:18 GMT

Hi experts,

I have a pivot table with two dimensions (histDate, Group) and two expressions (Value1, Value2).

In the histDate dimension, right now I have two dates - 11/29/2018 and 11/30/2018.

The pivot table is now showing 11/29 and 11/30 data for Value1 and Value2,

now I want to keep 11/30 column, change the 11/29 column to the two days' difference, something like below screenshot:

How can I do it?

qvw file is attached.

Thanks!

hopkinsc — Wed, 05 Dec 2018 20:54:12 GMT

Hi,

I am unsure what you are trying to do.

Could you attach an excel file with your desired output please?

msmichael — Wed, 05 Dec 2018 21:06:47 GMT

OK. Pls see attached Excel sheet.

Basically, right now in my pivot table, I have both 11/29 column and 11/30 column for Value1 field and Value2 field.

I want to change the 11/29 columns so that the differences of the values between the two days show in this column..