topic Re: Data with record number and step progress problem in QlikView

Data with record number and step progress problem

geogou1973 — Fri, 09 Aug 2013 12:42:37 GMT

Hello.

I have create a straight chart and the data are sorting decending by the amount. Also i have a column that has record number and the name of cardholder.

I have create also an input field that you can give the step.

Step

The data are like the table below

RecordNo	Cardholder	Amount
1	poiuy	9876
2	kkk	4567
3	Guy	1000
4	wedf	1000
5	Dav	850
6	Best	701
7	qwr	567
8	qwer	432
9	plom	321
10	Mam	300
11	jjj	234
12	Nana	139
13	llop	123
14	tyj	98
15	Devra	80
16	Gibson	75
17	fgns	56
18	plo	56
19	Kim	50
20	sdfg	34
21	Jim	30
22	Jane	25

When you give the step e.g 3 in another straight chart you have the data of cardholders that have the record number 3, 6, 9, 12, 15 e.t.c

RecNo	Cardholder
6	Best
9	plom
12	Nana
15	Devra
21	Jim

The problem is that i lose the data that i have the same Amount in the first table e.g i lose the record number 3 and18.

Is there somebody to help me to not lose that data ?

I attach the QVW.

Thanks in advance.

Re: Data with record number and step progress problem

swuehl — Fri, 09 Aug 2013 12:52:49 GMT

Try

=aggr(if(mod(rank(sum(Amount),4,0),Step)=0,rank(sum(Amount)),0),Cardholder)

as your calculated dimension.

Re: Data with record number and step progress problem

geogou1973 — Fri, 09 Aug 2013 14:22:54 GMT

Does not word correctly at all because i want in the chart
Cardholders by Step to show record 3 , 6, 9, 12 e.t.c

and not 3-4 because the results are incorrect if you see in the chart Cardholders below the chart

Cardholders by Step.

Re: Data with record number and step progress problem

swuehl — Fri, 09 Aug 2013 15:18:29 GMT

It's just a question how you sort the Cardholder having same sum(Amount), and to format the rank as number, not as text.

You are using advanced aggregation in your calculated dimension, which always sort its dimension values by load order, so you need to sort the Cardholder in your second table also by load order.

Check attached.

Re: Data with record number and step progress problem

geogou1973 — Sun, 11 Aug 2013 15:13:43 GMT

Thank you very much.

It works perfect.