Show Top result by weeks

[blurrblurr]

I have the following data

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

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

[uacg0009 · Accepted solution]

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.

Aiolos Zhao

[blurrblurr · Accepted solution]

Thanks! I think this works for me. Thanks you