Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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/...
Thank you Dalton,
I'm looking for a way to filter range of "ranks" (that the table will present them only)