Rank in text object

[nareshthavidishetty]

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

[antoniotiman]

Try

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

Regards,

Antonio

[maniram23]

Hi,

Try This one .

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

or

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

Regard

[tyagishaila]

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

[tyagishaila]

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!

[vikasmahajan]

See Attached Details document on RAnk hope this helps you

Vikas

[nilapril2010]

Hi,

Please check with this

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

Regards

Nilanjan

[qlikview979]

Hi If you want in Text Object

Try this

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

[nareshthavidishetty]

Hi Antonia,

Thanks for your quick reply,

Could you please find the attachment of sample QVW

@ !

[antoniotiman]

See Attachment.

Regards,

Antonio