topic Re: Show Top result by weeks in App Development

Show Top result by weeks

blurrblurr — Sat, 16 Nov 2024 06:47:17 GMT

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 — Wed, 23 Jan 2019 06:52:39 GMT

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 — Wed, 23 Jan 2019 08:27:48 GMT

Thanks! I think this works for me. Thanks you