Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to add column to a pivot table

Hi,

I made a pivot table like below (without the yellow column)

1.JPG

Now I want add the yellow column which value is the difference between last two month (in this case,201404 and 201403) to the right of the pivot.

Can Qlikview do this?

Thank you very much for your help.

Best regards

Wei


10 Replies
Not applicable
Author

Yes,when I move value below FQ, it works.

So I can't use SecondaryDimensionality() when values at right of country?

1.JPG

Because besids diff, I still have one column which will use the value of diff, is it possible?

Best regards,

Wei