topic dataset contains priority and category - how to display a table with top 5 in App Development

dataset contains priority and category - how to display a table with top 5

new2qlik2 — Thu, 29 Sep 2022 04:37:17 GMT

I have a dataset where i have items with an "Assigned priority" 1 - 100; and a category "a, b, c, d". So there's a row with priority 1 -100 in category a; a row with priority 1-100 in category b; etc. How can i display top 5, in a particular category in a table?

Re: dataset contains priority and category - how to display a table with top 5

MendyS — Thu, 29 Sep 2022 07:02:53 GMT

Hi @new2qlik2

first - you need to use with group by and order by functions to make order in your data set,
after that load to TempTable and used with peek or preview functions to filter to just 5

Re: dataset contains priority and category - how to display a table with top 5

new2qlik2 — Thu, 29 Sep 2022 14:01:34 GMT

Thanks MendyS! Can I ask two follow ups:

1) Why can't i sort/group in the same table while loading?

2) I tried using "rank" and aggr but that didn't work - any thoughts on why that didn't work?

Re: dataset contains priority and category - how to display a table with top 5

MendyS — Sun, 02 Oct 2022 06:34:06 GMT

Hi @new2qlik2

1. you can use group by and order at the same time, if you send me the error I will try to help.
2. about rank - Solved: Re: Ranking in Script - Qlik Community - 43866