How to achieve sorting based on measure in Heatmap

[Aditya_Chitale]

Hi All,

I am trying to achieve sorting based on measure in Heatmap. I am using the chart available in Qlik Visualization Bundle but it is giving me randomly sorted values. I want the sorting in descending order which will provide me a gradient type of look.

But in sorting, I have already sorted based on Month. So, is there any way to sort according measure ?

Thanks & regards,

Aditya

[Anonymous]

You could sort the other dimension in the Heatmap by your measure's expression. 

[Aditya_Chitale]

There is no other dimension. I have only 1 dimension and 2 measures

Regards,

Aditya

[Anonymous]

Hi,

It must be a misunderstanding, the heatmap is based on 2 dimensions and 1 measure.

Could you please share a screen capture?

[Aditya_Chitale]

Hi,

Sorry for my previous statement. You were right, there are 2 dimensions and 1 measure but I tried adding the measure expression in second dimension as well but it didn't work.

I used this sorting expression in the second measure:

sum(Aggr_Rec_Val_ML)/sum(total<[CNOD FiscalMonth]>{<[CNOD BucketDays]=>}Aggr_Rec_Val_ML)

Regards,

Aditya