Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
shahafei2
Creator
Creator

Fix filter in chart bar according to calculated expression

Hi all,

 

I have a chart table that ranking customers according to their purchases in a set period(User decision)

it is possible to filter the chart in a way that it will present customers with a specific rank?

 

 

2 Replies
Dalton_Ruer
Support
Support

If you set the Sort Order to be the numeric value of an expression and not the customer names then it should happen automatically for you. Below I've pasted an image of a table sorted by the State name, and the exact same table where all I did was click the header for Readmit Count and now the States are in the order they are ranked for that measure. 

Dalton_Ruer_0-1620236661856.png

Qlik also provides a RANK function you can use to Rank it based on something that might not be in the chart and you would use that for the Sort Order expression. https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

 

 

shahafei2
Creator
Creator
Author

Thank you Dalton,

 

I'm looking for a way to filter range of  "ranks" (that the table will present them only)