topic Re: filter /slider on the basis of rank function in App Development

filter /slider on the basis of rank function

vishavb007 — Mon, 26 Oct 2020 11:03:16 GMT

Hi All,

Hope you are doing well!

I need help as i need to show a filter on my sheet which can filter top 5,10,15,20... brands by sales.

It means in my table there are 1000 brands by sales, when i choose top 5 brands then in table rank wise top 5 brands will be coming up similarly for top 10 & so on.

I know i need to use variable extension which is available in qlik bundle, but i am not able to write expression and how to link that variable extension with my table, Pls help me with the expression

Regards

Vishav Bhatia

Re: filter /slider on the basis of rank function

Kushal_Chawda — Mon, 26 Oct 2020 11:41:45 GMT

@vishavb007 see the attached qvf. check the Dimension properties for setting

Re: filter /slider on the basis of rank function

vishavb007 — Mon, 26 Oct 2020 12:06:03 GMT

Hi,

Thanks for sharing the qvf, it's simple and worked for me, I was tying the rank function and what not.

Thanks again for sharing it with me.

Regards

Vishav Bhatia

Re: filter /slider on the basis of rank function

vishavb007 — Mon, 26 Oct 2020 13:48:28 GMT

Hi Kush,

This solution was helpful but I need some more help with this this, as I have 3 dimensions which are city, products, country.

so i need to to show top 10 by city, by product & by country, and i am creating a chart on the basis of these so when i choose top 10 by products so chart should change acc to that, similarly for others.

And what should i keep so that if i dont want to show any of it like top 10,15,20, just want to show total how many are there.

Please help me out, i will be very thankful to you.

Regards

Vishav Bhatia