Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
JacobJones
Creator
Creator

Sorting Heatmap dimension by the highest average of its measure

I have a heatmap. The two dimensions are the date a case started, by month, and the partner who the case belongs to. The measure is the average cost of the cases. When I sort by the average cost it is sorting by average cost per month but I would like to sort by average cost across all time that is showing, not just if a partner happens to have one expensive month. One partner has an outlier month so is appearing at the top, where I want whoever  has the overall highest cost to appear at the top. 

I am not seeing a sort by expression option anywhere. How can I sort by total average and not just who has a month with the highest average?

 

 

3 Replies
Rodj
Luminary Alumni
Luminary Alumni

First things first, I don't know what version of Qlik Sense you are using but the heatmap chart from the visualisation bundle allows sorting by expression for dimensions. You can't sort by expression for any measure that I'm aware of if that's where you are looking. You'll need to formulate an expression for your first dimension, possibly with a TOTAL clause or using an AGGR function in your average calculation.

JacobJones
Creator
Creator
Author

Hi Thanks for the help. I am using the September 2020 build of Qlik Sense. As you can see in the image below, I am not seeing any option to sort by expression. Is it because we are on an older build? Is it possible to download just the newer heatmap extension on its own? 

 

thumbnail_image.png

Rodj
Luminary Alumni
Luminary Alumni

I'm working with a June 2020 version that definitely looks different. In fact your image doesn't look like the normal properties pane for a chart object at all, it looks like some kind of custom development or extension perhaps. Someone is going to take a look at this and think I'm stupid but I can't place where in Qlik Sense that is from. The standard sort section of the standard properties looks more like this image (I'm using Chrome on Windows 10 and this is in a heatmap chart from the Qlik Visualisation bundle included with Qlik Sense enterprise June 2020):

Rodj_0-1612838308353.png

Can you provide a bit more context about where you've taken your image from? Sorry if this seems a bit basic.