Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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.