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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Sai_Krishna
Contributor III
Contributor III

Calculate for every column in Pivot Table

Hi,

I have a pivot table with Weeks in Columns. I want to get two weeks before data matching with different column (Version Date).

Week_Start is column in pivot table and it is date integer.

Measure in Pivot Table:
SUM({<Version_Date = {"$(=Date(Week_Start -14,'DD-MMM-YY'))"}>}Value).

Above expression is working fine if I select one Week_Start but it should work with out any week filter. I am not able to create mock up data, I tried to capture the requirement in below screenshot.

clipboard_image_0.png

Regards,
Sai Krishna.

Labels (2)
0 Replies