topic Re: Sorting on expression in QlikView

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

felipedl — Fri, 04 Jan 2019 12:27:05 GMT

Whats the expected outcome? To order by the percentage you have on chart?
Can you share the app? The expression is quite large and without context, its hard to evaluate what's the best approach to do it.

Re: Sorting on expression

manu1512 — Fri, 04 Jan 2019 13:06:21 GMT

Hi ,

Yes i am trying to sort by the percentage

Re: Sorting on expression

felipedl — Mon, 07 Jan 2019 12:27:53 GMT

Whats the expression your using to calculate the percentage?
That's the one you need to sort it out by the calculation, rather than the dimension itself.
Problem is, you can have multiple calculations being made by chart and can get quite confusing to sync all up.
Can you share the app?