Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
louisdch
Contributor III
Contributor III

Pivot table calculate difference

Hi all,

How could we calculate the difference of between yearwk in Pivot table?

Capture.PNG

 

Best Regards,

Louis

4 Replies
sunny_talwar

What exactly are you hoping to get? Based on the image above, what is your expected output?
louisdch
Contributor III
Contributor III
Author

Hi Sunny,

I would like to calculate the difference between the YEARWK on each row.
Eg. there is another column under "201845" which show the difference with "201844" (Value in 201845 - value in 201844)

Best Regards,
Louis
louisdch
Contributor III
Contributor III
Author

Hi Sunny,

 

If further clarification is needed, please let me know.

 

Best Regards,

Louis

louisdch
Contributor III
Contributor III
Author

Hi Sunny,

any idea?

Best Regards,

Louis