Discussion board where members can learn more about Qlik Sense App Development and Usage.
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
Go to Solution.
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".
Thanks! I think this works for me. Thanks you