topic Fix filter in chart bar according to calculated expression in QlikView

Fix filter in chart bar according to calculated expression

shahafei2 — Thu, 29 Apr 2021 11:07:02 GMT

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?

Re: Fix filter in chart bar according to calculated expression

Dalton_Ruer — Wed, 05 May 2021 17:46:26 GMT

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/RankingFunctions/rank.htm

Re: Fix filter in chart bar according to calculated expression

shahafei2 — Sun, 09 May 2021 07:19:14 GMT

Thank you Dalton,

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