Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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.