topic Re: interactive Row number in QlikView

interactive Row number

todtliat01 — Sun, 04 Jan 2015 10:34:03 GMT

I have a project where I want to number the rows in the chart. However I want rows with the same value on the field x, to stay the same. So for example rows 5-7 will indicate 5 and the next row will be 6 rather than 8 and so on.

I am attaching a sample qvw

Thanks

Liat

Vatat_Tat_Tkufa.PROJECT	Vatat_Tat_Tkufa.TEUD_ZEHUT	RowNum
		35
700079	067168666	1
700100	008164071	2
700141	000000077	3
700142	000000082	4
700200	005185574	5
700200	011134384	6
700200	050348952	7
700201	009805995	8
700202	005393194	9
700202	041383126	10
700203	005185574	11
700203	050348952	12
700204	053581849	13
700205	011134384	14
700205	069002426	15
700206	011134384	16
700206	069002426	17
700207	065248015	18
700208	009805995	19
700208	043594449	20
700209	041383126	21
700209	064439243	22
700210	009805995	23
700210	043594449	24
700210	056023575	25
700211	041383126	26
700212	009805995	27
700213	041383126	28
700213	064439243	29
700214	041383126	30
700215	041383126	31
700216	041383126	32
700216	064439243	33
700217	041383126	34
700217	064439243	35

Re: interactive Row number

ecolomer — Sun, 04 Jan 2015 10:51:13 GMT

Is that you need?

Re: interactive Row number

its_anandrjs — Sun, 04 Jan 2015 11:04:09 GMT

You can use calculated dimension also.

Dim1:- =Aggr( Rank( -Vatat_Tat_Tkufa.PROJECT), Vatat_Tat_Tkufa.PROJECT)

Dim2:- Vatat_Tat_Tkufa.TEUD_ZEHUT

Expre:- Only( Vatat_Tat_Tkufa.PROJECT )

Regards

Anand

Re: interactive Row number

ecolomer — Sun, 04 Jan 2015 11:20:15 GMT

more ..

Re: interactive Row number

todtliat01 — Sun, 04 Jan 2015 11:38:52 GMT

That really helped but I have another question. I have more dimensions that are the sort of the table, I would like to rank according to them as well. I am attaching the new file.

Thanks for all your help.

Liat

Re: interactive Row number

ecolomer — Sun, 04 Jan 2015 11:44:01 GMT

Sorry but the file are wrong

Can you upload one more

Re: interactive Row number

todtliat01 — Sun, 04 Jan 2015 11:46:43 GMT

another try

Re: interactive Row number

ecolomer — Sun, 04 Jan 2015 11:52:47 GMT

Now is OK,

What is the new requeriment?

the rank for another column?

Re: interactive Row number

todtliat01 — Sun, 04 Jan 2015 11:57:55 GMT

I have a constant sort: Sponsor, Project, ID. I need the row numbers to advance but if I have more than one line on the Project, all the lines for this project should be the same and advance afterwards without skipping numbers. Much like what you have done, only the Sponsor column needs to be part of the rank and the sort.

Thanks Liat

Re: interactive Row number

ecolomer — Sun, 04 Jan 2015 12:16:30 GMT

Is this?

Re: interactive Row number

todtliat01 — Sun, 04 Jan 2015 12:22:21 GMT

Not exactly.

I need the sponsor to be part of my sort. I need to sort the table according to this field and rank according to the project.

I hope you understand what I mean.

Thanks L

Re: interactive Row number

ecolomer — Sun, 04 Jan 2015 12:38:18 GMT

The rank for the project are absolute or into the sponsor?

Re: interactive Row number

todtliat01 — Sun, 04 Jan 2015 12:52:34 GMT

This is how I would like to have it:

Sponsor	Project	ID	Only( Vatat_Tat_Tkufa.PROJECT )	=Aggr( Rank(-Vatat_Tat_Tkufa.PROJECT), Vatat_Tat_Tkufa.PROJECT)
			-
21Ventures	710245	013513148	710245	1996	1
Aaron and Wally Fish	720606	051533206	720606	4396	2
Abbott Labratories	711160	050672005	711160	2911	3
Abbott Labratories	711198	004083390	711198	2949	4
Abe and Kathryn Selsky	702386	000000016	702386	595	5
Abe and Kathryn Selsky	705155	304748882	705155	1407	6
Abe and Kathryn Selsky	720117	004727012	720117	3908	7
Abe Fish Mr.	720625	027340686	720625	4415	8
Abisch-Frenkel Foundation for the Promotion of Life Sciences	700572	025469149	700572	332	9
Abisch-Frenkel Foundation for the Promotion of Life Sciences	700573	059063388	700573	333	10
Abisch-Frenkel Foundation for the Promotion of Life Sciences	700574	024936908	700574	334	11
Abisch-Frenkel Foundation for the Promotion of Life Sciences	702563	007510738	702563	705	12
Abisch-Frenkel Foundation for the Promotion of Life Sciences	703410	024384372	703410	1026	13
Abisch-Frenkel Foundation for the Promotion of Life Sciences	703411	013209267	703411	1027	14
Abisch-Frenkel Foundation for the Promotion of Life Sciences	710238	023621162	710238	1989	15
Abisch-Frenkel Foundation for the Promotion of Life Sciences	710239	022803068	710239	1990	16
Abisch-Frenkel Foundation for the Promotion of Life Sciences	710699	032164055	710699	2450	17
Abisch-Frenkel Foundation for the Promotion of Life Sciences	710700	308675735	710700	2451	18
Abisch-Frenkel Foundation for the Promotion of Life Sciences	710707	027911353	710707	2458	19
Abisch-Frenkel Foundation for the Promotion of Life Sciences	710707	320515166	710707	2458	19
Abisch-Frenkel Foundation for the Promotion of Life Sciences	711255	027905744	711255	3006	20
Abisch-Frenkel Foundation for the Promotion of Life Sciences	711256	029568599	711256	3007	21
Abisch-Frenkel Foundation for the Promotion of Life Sciences	711260	028703783	711260	3011	22
Abisch-Frenkel Foundation for the Promotion of Life Sciences	711315	024285751	711315	3066	23