topic Re: How to achieve sorting based on measure in Heatmap in App Development

How to achieve sorting based on measure in Heatmap

Aditya_Chitale — Sat, 16 Nov 2024 18:31:21 GMT

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

Re: How to achieve sorting based on measure in Heatmap

Anonymous — Mon, 08 Jun 2020 17:58:36 GMT

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

Re: How to achieve sorting based on measure in Heatmap

Aditya_Chitale — Mon, 08 Jun 2020 18:23:00 GMT

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

Regards,

Aditya

Re: How to achieve sorting based on measure in Heatmap

Anonymous — Mon, 08 Jun 2020 18:29:48 GMT

Hi,

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

Could you please share a screen capture?

Re: How to achieve sorting based on measure in Heatmap

Aditya_Chitale — Mon, 08 Jun 2020 19:05:53 GMT

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