topic sort number in QlikView

sort number

Wed, 01 Dec 2010 06:40:41 GMT

I have a straight table .
This results in the table below:

rank	rank2	store	Products	color	Qty
?	?	?	?	?	90
1	1	Cat2	Pdt2	7	18
1	1	Cat2	Pdt4	9	10
1	1	Cat2	Pdt3	8	9
1	1	Cat2	Pdt1	5	6
2	1	Cat3	Pdt4	9	10
2	1	Cat3	Pdt3	8	9
2	1	Cat3	Pdt2	7	8
2	1	Cat3	Pdt1	5	6
3	1	Cat1	Pdt4	4	5
3	1	Cat1	Pdt3	3	4
3	1	Cat1	Pdt2	2	3
3	1	Cat1	Pdt1	1	2

I want to show three row for store is cat2 and cat1 and cat3.
I have created an expression using rowno() or rowno(total) but it didn't work
i use calcuate demension =aggr(rank(sum(Qty)),store,Products,color) but it only show 1
i want to show 1,2,3,4

i want to show the result below

rank	rank2	store	Products	color	Qty
?	?	?	?	?	90
1	1	Cat2	Pdt2	7	18
1	2	Cat2	Pdt4	9	10
1	3	Cat2	Pdt3	8	9
1	4	Cat2	Pdt1	5	6
2	1	Cat3	Pdt4	9	10
2	2	Cat3	Pdt3	8	9
2	3	Cat3	Pdt2	7	8
2	4	Cat3	Pdt1	5	6
3	1	Cat1	Pdt4	4	5
3	2	Cat1	Pdt3	3	4
3	3	Cat1	Pdt2	2	3
3	4	Cat1	Pdt1	1	2

Thanks in ADVANCE!

sort number

renjithpl — Wed, 01 Dec 2010 08:25:25 GMT

if i understood your question,

in Rank2 if color is one of your field then you can use below

= Rank(color)

Regards

Ranjit

sort number

rwunderlich — Wed, 01 Dec 2010 09:19:48 GMT

It looks like you want to rank within store so the expression would be:

=aggr(rank(sum(Qty)),store)

-Rob

sort number

Wed, 01 Dec 2010 09:35:03 GMT

Thanking you for your reply. but i want rank qty by store

sort number

Wed, 01 Dec 2010 09:39:36 GMT

Thanking you for your reply .rob wunderlich very much thanks for you

but =aggr(rank(sum(Qty)),store) only show rank

i want show rank2

rank	rank2	store	Products	color	Qty
?	?	?	?	?	90
1	1	Cat2	Pdt2	7	18
1	2	Cat2	Pdt4	9	18
1	3	Cat2	Pdt3	8	18
1	4	Cat2	Pdt1	5	18
2	1	Cat3	Pdt4	9	10
2	2	Cat3	Pdt3	8	9
2	3	Cat3	Pdt2	7	8
2	4	Cat3	Pdt1	5	6
3	1	Cat1	Pdt4	4	5
3	2	Cat1	Pdt3	3	4
3	3	Cat1	Pdt2	2	3
3	4	Cat1	Pdt1	1	2