Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try
=Concat(DISTINCT Country,Chr(10), Aggr(NODISTINCT Rank(Sum({<Product={'P2'}>} Sales),4),Country ))
Regards,
Antonio
Hi,
Try This one .
Aggr(Rank(Sum(Sales)),Country)
or
Only({<Product = {'P2'}>} Aggr(Rank(Sum(Sales)), Country))
Regard
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
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!
See Attached Details document on RAnk hope this helps you
Vikas
Hi,
Please check with this
=Concat('US',Aggr(Rank(Sum({<Country={'US'}, Product={'P2'}>} Sales)),Country,Product),'RANK for Product(','P2',')')
Regards
Nilanjan
Hi If you want in Text Object
Try this
='Rank for Product '&only(Product)&': '&aggr(rank(TOTAL sum({1} Sales)), Country)
Hi Antonia,
Thanks for your quick reply,
Could you please find the attachment of sample QVW
@ !
See Attachment.
Regards,
Antonio