topic Re: Rank in QlikView

Rank

tyagishaila — Sat, 11 Apr 2015 09:13:01 GMT

Hello,

I am finding top 5 items

1. on the basis of whole item list

2. on the basis of items available at each store.

Suppose item A,N,O,R,S are top 5 items as whole and it may be possible item A,B,C,D,E are on top at Store1 and N,R,T,U,V

are on top at Store2.

How can I achieve this?

Thanks

hic — Sat, 11 Apr 2015 09:52:53 GMT

Rank( ... ) will give you the rank within each store

Rank( total ... ) will give you the rank of the whole list.

HIC

Anonymous — Sat, 11 Apr 2015 10:51:33 GMT

Hi Shaila,

PFA file. Whatever requirement I could understand based on that I created it.Hope it is useful.

All the best.

Cheers,

Ritesh Pathak

MK_QSL — Sat, 11 Apr 2015 11:27:56 GMT

Create a Pivot Table

Dimensions

Store

Item

Expression

if(rank(sum(Sales))<=5,sum({<Store={"=rank(sum(Sales))<=5"}>} Sales))

tyagishaila — Sat, 11 Apr 2015 18:34:03 GMT

Thanks Ritesh,

My query is little bit different from your solution.

Actually first I want to find out top 5 items in overall business

and second at store level, it means at each store those 5 items are on top sale. this item list will different for each store.

Regards,

Shaila

Anonymous — Sat, 11 Apr 2015 20:25:26 GMT

Hi Shaila,

Your problem got fixed? If not, please send me some sample data in excel @ riteshpathak10@gmail.com and I will create a solution for you.

Cheers,

Ritesh Pathak