Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You could sort the other dimension in the Heatmap by your measure's expression.
There is no other dimension. I have only 1 dimension and 2 measures
Regards,
Aditya
Hi,
It must be a misunderstanding, the heatmap is based on 2 dimensions and 1 measure.
Could you please share a screen capture?
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