Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sort by Expression - Extension 2 Dimensional Heatmap

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)

Heatmap.PNG

If i switch the two Dimensions, then the second expression (Month) works well, but then the first expression (Discount) does not sort right:

heatmap_switch dimension.PNG

Do you have any experience with this extension and can help me to sort both Dimensions right?

Best regards,

Janina

4 Replies
shraddha_g
Partner - Master III
Partner - Master III

did you try sorting options for that dimension?

Not applicable
Author

What do you mean with sorting options?

Do you mean the alternatives 'sort numerically' or 'sort alphatbetically'?

shraddha_g
Partner - Master III
Partner - Master III

yes. That is what I mean.

Not applicable
Author

I tried also the sorting options 'sort numerically' and 'sort alphabetically, but these options didn't work either.