Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
leni_harishwara
Partner - Contributor III
Partner - Contributor III

Rank Function

Hi All,

I would like to get the Rank of a product from the list of products based on different conditions like Area, Country.

So in my source I have Area, Country, Product and so on.

I would like to get the Rank of a Product 'A' from the list of products in each country and area.

test.png

So as you could see from the above screenshot I have highlighted the Product. So in a Area and in a country the Rank of the product is 36 and 27.

I need the same detail in a pivot table but not for all products only that particular product.

Area            Country                        Rank of the Product Zrnvtl

ATSK&G     KWCVDSWM                    36

                    JETKB JTCGNPHX          27

Something like this.

Can anyone please help me to get this sorted out?

Regards,

Leni Harishwaran

2 Replies
tresesco
MVP
MVP

Do you want to select a certain product and check it's rank? Or, it's always that specific product? Could you share your sample qwv?

leni_harishwara
Partner - Contributor III
Partner - Contributor III
Author

It is always the specific product. Sorry now I don't have a sample file to share I try to create a sample which satisfy my requirement and share.

Regards,

Leni