topic Re: Rank in text object in QlikView

Rank in text object

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I am new to Qlikview and I have a requirement like, i want to show particular product rank for each country.

Ex:

Country Product Sales

US P1 10

US P2 20

US P3 30

US P4 40

UK P1 100

UK P2 800

UK P3 400

UK P4 400

O/P :

In Text Object: US - 2 nd RANK for Product(P2)

UK- 1st RANK for Product(P2)

Thanks and Regards,

Naresh

Re: Rank in text object

antoniotiman — Fri, 01 Jul 2016 11:37:15 GMT

Try

=Concat(DISTINCT Country,Chr(10), Aggr(NODISTINCT Rank(Sum({<Product={'P2'}>} Sales),4),Country ))

Regards,

Antonio

Re: Rank in text object

maniram23 — Fri, 01 Jul 2016 11:37:29 GMT

Hi,

Try This one .

Aggr(Rank(Sum(Sales)),Country)

Only({<Product = {'P2'}>} Aggr(Rank(Sum(Sales)), Country))

Regard

Re: Rank in text object

tyagishaila — Fri, 01 Jul 2016 11:50:37 GMT

Dim: Country and Product

Expression: Rank(aggr(Sum(SalesRank),ProductRank,CountryRank)) if you want max Sale rank 1

or Rank(aggr(-Sum(SalesRank),ProductRank,CountryRank)) if you want min Sale rank 1

Re: Rank in text object

tyagishaila — Fri, 01 Jul 2016 12:00:58 GMT

to display rank in Text Object, you can create Rank in script

by using rowno() and order of Sales as asc.

Try it once,

Hope it will work!

Re: Rank in text object

vikasmahajan — Fri, 01 Jul 2016 12:02:54 GMT

See Attached Details document on RAnk hope this helps you

Vikas

Re: Rank in text object

nilapril2010 — Fri, 01 Jul 2016 12:06:58 GMT

Hi,

Please check with this

=Concat('US',Aggr(Rank(Sum({<Country={'US'}, Product={'P2'}>} Sales)),Country,Product),'RANK for Product(','P2',')')

Regards

Nilanjan

Re: Rank in text object

qlikview979 — Fri, 01 Jul 2016 12:10:55 GMT

Hi If you want in Text Object

Try this

='Rank for Product '&only(Product)&': '&aggr(rank(TOTAL sum({1} Sales)), Country)

Re: Rank in text object

nareshthavidishetty — Fri, 01 Jul 2016 12:23:03 GMT

Hi Antonia,

Thanks for your quick reply,

Could you please find the attachment of sample QVW

@ !

Re: Rank in text object

antoniotiman — Fri, 01 Jul 2016 12:44:36 GMT

See Attachment.

Regards,

Antonio

Re: Rank in text object

nareshthavidishetty — Fri, 01 Jul 2016 13:03:24 GMT

Hi,

I need the rank of particular product for country,

My requirement is,

i have a different products in that for product 'P2 'compare with other products for country=US

As posted above, i want to see the rank of product 'P2 'for country US, Like

product 'P2' rank in US is 2. So i want to show 2 in text object.

Re: Rank in text object

antoniotiman — Fri, 01 Jul 2016 13:45:42 GMT

Try

='For US Rank is = '&Max({<COUNTRY={'US'}>} Aggr(Rank(TOTAL Sum({<PRODUCT={'P2'},COUNTRY=>} SALES),4),COUNTRY))

See Attachment

Re: Rank in text object

sunny_talwar — Fri, 01 Jul 2016 14:14:02 GMT

What exactly is your intent here? Are you looking for Rank based on selection made in Country or Product? How many text boxes are you looking to get? Can you may be provide some details which can guide one of us to what exactly might you be looking for?

Best,

Sunny

Re: Rank in text object

nareshthavidishetty — Mon, 04 Jul 2016 03:53:42 GMT

Hi Sunny sorry for delay in reply,

I have a country wise different products ,My requirement is i want to compare Product 'P2' sales with competitor products for particular country and it's Rank.

Like that i want to show the rank of product 'P2' for different countries as well in text objects..

eg:

Country Product Sales

US P1 10

US P2 20

US P3 30

US P4 40

UK P1 100

UK P2 800

UK P3 400

UK P4 400

in text object i want to show like for Product 'P2' is:

US:Rank-2

UK: Rank -1

Thanks,

Naresh

Re: Rank in text object

tyagishaila — Mon, 04 Jul 2016 05:21:09 GMT

For US write in Text Object

=Aggr(Rank(Sum({<Country={'US'},Product=>}Sales)),Country,Product)

For UK:

=Aggr(Rank(Sum({<Country={'UK'},Product=>}Sales)),Country,Product)

You can get RANK for different products

Re: Rank in text object

nareshthavidishetty — Mon, 04 Jul 2016 05:48:59 GMT

Hi tyagishaila,

Thanks of your reply,

I want to select product as well,

=Aggr(Rank(Sum({<Country={'US'},Product={'P2'}>}Sales)),Country,Product)

when i am including Product ={'P2'} the value is coming 1,but required result is 2.

Re: Rank in text object

susovan — Mon, 04 Jul 2016 09:11:44 GMT

Try this expression,

Aggr(Rank(Sum({<Product=>} Sales)),Product)