Get top sold product country wise in qlik sense

[Shahzad_Ahsan]

Hi Friends

I want, top sold product country wise in table chart.

Something like this:

Country Name	Product Name	Sales Amount
USA	P1	125148
India	P6	362548

I have attached sample excel file and .qvf

[OmarBenSalem · Accepted solution]

Do as follow:

create a simple table:

as dimensions:

dim 1 : Country

dim 2: ProductName

Measure : if(rank(sum(Quantity),Country,ProductName)=1,Sum(Quantity),0)

then, under adds on: uncheck show zero values

the result would be : (see the attached app)

[Shahzad_Ahsan]

Hi Omar

Thanks for your answer.

It is working perfectly fine, but sorting is not working on this column, I don't know why.

[OmarBenSalem]

yes, since we're forcing things; sorting won't be possible directly when taping on the column title; u can sort by country: and put as an expression:

sum(Quantity)

:

result:

Don't forget to close the thread by marking the correct answer as correct and the helpful ones as helpful

[Shahzad_Ahsan]

Thanks Omar