Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello together,
I use the Qlik Sense Extension 2 Dimensional Heatmap.
There i use 2 Dimension that i want to sort by the Expression function.
Here are the expressions:
1. Match([Discount],'<20%','20%-40%','40%-60%','60%-80%','>80%')
2. Match([Month],'Nov','Dec','Jan','Feb','Mar','Apr','May','Jun','Jul','Aug')
The first expression (Discount) works well, but the second expression (Month) does not sort the values right (see picture)
If i switch the two Dimensions, then the second expression (Month) works well, but then the first expression (Discount) does not sort right:
Do you have any experience with this extension and can help me to sort both Dimensions right?
Best regards,
Janina
did you try sorting options for that dimension?
What do you mean with sorting options?
Do you mean the alternatives 'sort numerically' or 'sort alphatbetically'?
yes. That is what I mean.
I tried also the sorting options 'sort numerically' and 'sort alphabetically, but these options didn't work either.