Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Making a calculation based on cell values in a pivot table.

I am using a pivot table to show sales data and have displayed "Year" on the horizontal axis. I want to calculate the difference between the years. In Excel I would simply do something like "=A1-B1". Is it possible to do something like this in Qlik?

3 Replies
Not applicable
Author

Hi Chris Philpot ,

You can try Before and After Function .

Regards,

Chakravarthy.

Not applicable
Author

You can try use Set Analisys, there are many information on this forum.

Not applicable
Author

Hi ,

Please find your solution here

http://community.qlik.com/forums/t/27247.aspx

some nice posting some by John.

Regards,

Ravi