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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
tsachdev421
Contributor II
Contributor II

Pivot Table

Minimum Dimensions and Measures required to achieve below layout in Qlik Sense.

 

  Rupee
  CY LY
Week Shop % (+/- LY) TOTAL Shop % TOTAL
WK1 13,354.7 33.2% 6.0% 40,279.6 11,082.4 27.1% 40,849.0
Labels (3)
1 Reply
Or
MVP
MVP

This looks like a fairly standard pivot table, except that the columns aren't identical between CY and LY which Qlik doesn't do. If you need this exact layout, you'll have to make each column separate and use something like ValueList() to generate the dimensions, most likely.