Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
manu1512
Creator
Creator

Sorting on expression

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)

 

3 Replies
felipedl
Partner - Specialist III
Partner - Specialist III

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.
manu1512
Creator
Creator
Author

Hi ,

Yes i am trying to sort by the percentage

felipedl
Partner - Specialist III
Partner - Specialist III

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?