Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
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
Partner
Partner

Re: Sort by Expression - Extension 2 Dimensional Heatmap

did you try sorting options for that dimension?

Not applicable

Re: Sort by Expression - Extension 2 Dimensional Heatmap

What do you mean with sorting options?

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

Partner
Partner

Re: Sort by Expression - Extension 2 Dimensional Heatmap

yes. That is what I mean.

Not applicable

Re: Sort by Expression - Extension 2 Dimensional Heatmap

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