topic Re: Top 10 Services based on first Dimension in qliksense Pivot table in App Development

Top 10 Services based on first Dimension in qliksense Pivot table

indra — Tue, 23 Jan 2024 08:22:52 GMT

Hi,

How can we get top 10 services based on first dimension in pivot table qliksense

anat — Tue, 23 Jan 2024 08:59:50 GMT

use Rank function

=if(Aggr(Rank(Sum(sales)), DEPT)<=10, DEPT , 'Others')

indra — Tue, 23 Jan 2024 09:09:54 GMT

I am using the same in the in the first dimension as calculated field, but that is not working.

anat — Tue, 23 Jan 2024 09:26:11 GMT

not working means ,getting error or not getting expected output.

indra — Tue, 23 Jan 2024 09:28:44 GMT

Not getting expected output.