Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
New Contributor

Firstsortedvalue error

Hi all,

I have requirement to get the TOP 3 products.  The data i got is as below:

Department    Category     Product      Runs  Type   Percent

Department B  Category 1  Product A  5           1      20%

Department B   Category 1  Product B  6           1    16.67%

Department B    Category 1 Product A  4            2    50%

Department B     Category 1 Product B  5         1      20%

Expected results is:

Department      Category      Runs    Type    Percent   TOP1 Product   Runs   Type  Percent     TOP2   Product Runs    Type   Percent

Department B    Category 1   20        5         25%         Product A          9          3       33.33%      Product B          11         2        18.18%

For getting the TOP1 Product i have written the code:

=FirstSortedValue(distinct Product, Num(Aggr(Rank( total sum(type) + sum(Percent),4),Department,Category)),1)

For getting the TOP1 Product Runs i have written the code:

=FirstSortedValue(distinct Run, Num(Aggr(Rank( total sum(type) + sum(Percent),4),Department,Category)),1)

I want to sum the Run for each product.

Please help me.

1 Reply

Re: Firstsortedvalue error