Rank as KPI object

[Florin2]

Hi,

I have the next table with this headers as data: ID Pharmacy | ID Card | Date where ID Pharmacy are distinct & ID Card are distinct. 

What i want to do is to have a KPI as object where when i selecting the ID Pharmacy to show me the Rank of ID Pharmacy selected by filter based on the count(ID Card).

I made the rank using the chart but i wanted to have as a KPI object. 

I'm working in Qlikview.

Thank you in advance, 

[rubenmarin]

Hi, you can try with =Aggr(Rank(TOTAL Count({<[ID Pharmacy]>} [ID Card])),[ID Pharmacy])

[Florin2]

Hi Ruben,

Thank you for your fdk.

Is working.

Best regards