Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

I need only display top 5 customer , it is possible to do it in QS table ?

Hi All

I have a table which list all company sales for last year .

I need only display top 5 customer , it is possible to do it in QS ?

Now it display all.

Paul

1 Solution

Accepted Solutions
MVP
MVP

Re: I need only display top 5 customer , it is possible to do it in QS table ?

Try this:

Sum({<year={2016}, COMPANY = {"=Rank(Sum({<year = {2016}>} sales)) < 6"}>} sales)

4 Replies
paulyeo11
Valued Contributor II

Re: I need only display top 5 customer , it is possible to do it in QS table ?

my QVF

alan_richmond
Contributor

Re: I need only display top 5 customer , it is possible to do it in QS table ?

2017-01-04_13-52-22.jpg

MVP
MVP

Re: I need only display top 5 customer , it is possible to do it in QS table ?

Try this:

Sum({<year={2016}, COMPANY = {"=Rank(Sum({<year = {2016}>} sales)) < 6"}>} sales)

paulyeo11
Valued Contributor II

Re: I need only display top 5 customer , it is possible to do it in QS table ?

Hi All

Thank you both sharing. Sunny approach is very good , because i just need to display top 5 company. Where Alan way is more simple , but then it give the last row as a summation of all other row. This approach also have it advantages , as it will display total amount of the top 6 till the rest customer customer sales. Any way i just notice that this version have this setting , remember ver 1 does not have this,

Paul