Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Shahzad_Ahsan
Contributor II

Get top sold product country wise in qlik sense

Hi Friends

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

Something like this:

Country NameProduct NameSales Amount
USAP1125148
IndiaP6362548

I have attached sample excel file and .qvf

1 Solution

Accepted Solutions
omarbensalem
Esteemed Contributor

Re: Get top sold product country wise in qlik sense

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)

Capture.PNG

4 Replies
omarbensalem
Esteemed Contributor

Re: Get top sold product country wise in qlik sense

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)

Capture.PNG

Shahzad_Ahsan
Contributor II

Re: Get top sold product country wise in qlik sense

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
Esteemed Contributor

Re: Get top sold product country wise in qlik sense

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)

:

Capture.PNG

result:

Capture.PNG

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

Shahzad_Ahsan
Contributor II

Re: Get top sold product country wise in qlik sense

Thanks Omar