Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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
MB