Top N Clients

[jagdishbr]

Hi I'm new to Qliksense. I'm trying to achieve Top N client in pivot table. i need to show top 10 client names based on measure profit and dimension FY23

I tried Sum({<Client_Name= {"(=Rank(Sum({<period={'FY23'}>}Profit))<=10)"}>}Profit) but not getting desired output.

What am i doing wrong here please educate me what am i doing here.

		FY23				FY22
Client Name	Client Type	Revenue	COGS	Profit	Profit%	Revenue	COGS	Profit	Profit%
A	Ins
B	Asset
C	Medi
D	Medi
E	Ins

[Rohan]

Hi @jagdishbr ,

You should put that rank restriction in the Dimension instead of the Measure. That will resolve this.

Something like : if(Rank(aggr(Sum({<period={'FY23'}>}Profit),Client_Name))<=10,Client_Name,null())

Regards,

Rohan.

[Padma123]

sum({<[Client Name]={"=rank(sum (Profit))<=10"},period={'FY23'}>}profit)

[Chanty4u]

Try this

Sum(

    {<Client_Name = P(

        Aggr(

            If(Rank(Sum({<period={'FY23'}>} Profit), 1, 1) <= 10, Client_Name),

            Client_Name

        )

    )>} Profit

)

[CHRIS_Singa]

Use the aggregation function , you will get it