Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
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
Employee
Employee

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)