topic Re: Straight table Top2 show in App Development

Straight table Top2 show

krmvacar — Thu, 27 Mar 2025 07:26:07 GMT

Hi ,

I have a flat table in qliksense as below. I am calculating the rate based on package number and country.What I want here is to show the 2 countries with the highest rates based on a package number. How can I do this?

Dimesion1= [Packege Number]

Dimension2=Category

Dimension3=Country

Measure=sum(ERFMG)/sum(total<MATNR,MATNR_SIPNO,[Packege Number]> ERFMG)

I want to result.

Packege Number Category Country-Top1 Ratio %-Top1 Country-Top2 Ratio %-Top2

0010936761 Primer BAE 64,1% Hindistan 35,9%

0009736567 Primer Kazakistan 68,6% Malezya 18,7%

Thank you so much.

Best Regards

Re: Straight table Top2 show

Clement15 — Wed, 02 Apr 2025 08:41:00 GMT

Hello,

Do you have a fake data set you could provide us with?

Re: Straight table Top2 show

Anil_Babu_Samineni — Wed, 02 Apr 2025 11:20:47 GMT

there are certain ways that we have, example you can try like this

Firstsortedvalue(Category, -Max(Aggr(sum(ERFMG)/sum(total<MATNR,MATNR_SIPNO,[Packege Number]> ERFMG), Category)), 1)