Qlik Community

Qlik Sense App Development

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

Highlighted
blurrblurr
New Contributor II

Show Top result by weeks

I have the following data

example.png

I need to show only the top 3 sales for every week

exampleresult.png

Can it be achievable with qliksense expression on table chart?

I have added an extra column for ranking but not sure how to show only the top 3 result per week

Tags (3)
2 Solutions

Accepted Solutions
Partner
Partner

Re: Show Top result by weeks

Hi,

Sure you can do this, and you don't need to use the "rank".

Please see the below screenshot:

Sorry my qlik sense version is Chinese, but you can find the same function in the same position.

Go to your table dimension firstly, then click the ">" button of Category column, 

you can see a function called "limitation" I think,  then choose the second one,

and change the value to "3", and deselect the "show others".

Please try.

Show Top result by weeks.PNG

Aiolos Zhao

blurrblurr
New Contributor II

Re: Show Top result by weeks

Thanks! I think this works for me. Thanks you

2 Replies
Partner
Partner

Re: Show Top result by weeks

Hi,

Sure you can do this, and you don't need to use the "rank".

Please see the below screenshot:

Sorry my qlik sense version is Chinese, but you can find the same function in the same position.

Go to your table dimension firstly, then click the ">" button of Category column, 

you can see a function called "limitation" I think,  then choose the second one,

and change the value to "3", and deselect the "show others".

Please try.

Show Top result by weeks.PNG

Aiolos Zhao

blurrblurr
New Contributor II

Re: Show Top result by weeks

Thanks! I think this works for me. Thanks you