Sorting on expression

manu1512 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have created a bar chart where i am sorting based on expression but when i am selecting a field the sorting is not working ..

Can any one help?? me in this

expression used :=round(count({<Equipment_isSMA_Upgrade_Eligible={1},Temp_isEquipmentNoContract={0},Report_Year=,Year=,Flag={1},Is_Deleted={'N'}>}distinct if(Mod_EquipmentStartDate<=Today() and Mod_ContractLineEndDate >=Today() and Mod_ContractLineStartDate <= Today(), Equipment_Id))
/Rangesum(Above(Sum({<Equipment_isSMA_Upgrade_Eligible={1},Flag={2},Year=,MonthYear=>}EquipmentCount),0,Rowno())),0.0001)

Re: Sorting on expression

miguelbraga — Fri, 04 Jan 2019 10:10:48 GMT

Hi there,

First of all please don't create more than one thread in the community, refer to this:

https://community.qlik.com/t5/New-to-QlikView/Sorting-on-expression/m-p/1526196#M367668

Second, can you give further information about the dimensions of the chart?

The sorting isn't working because of the Leadership field, please add to Set Analysis this condition:

Leadership=

This might solve your problem.

Hope it helps you!

Best regards

topic Sorting on expression in QlikView

Sorting on expression

Re: Sorting on expression