topic Re: consecutive number in QlikView

consecutive number

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

good day

I would like to help have the following problem

I have a table with a list of names I believe the number field ( 1,2,3 ... 10)

with this function as an expression if ( IsNull ( Above ( number) ) , 1, Above ( number) +1 )

as a result I throw this table

I need you to select any name you leave the original number example

select the image siguinte

Comercial Mexicana its original number is 6, when making the selection number 1 puts

my question is ...
as I can do so that when you select instead of 1 I respect the original number which is 6

thanks I hope you can help me greetings

Luis Espinoza

Re: consecutive number

sunny_talwar — Tue, 03 May 2016 16:39:20 GMT

Can you try this:

If(IsNull(Above(Only({1}number))), 1, Above(Only({1}number)) +1) * Avg(1)

Re: consecutive number

Anonymous — Tue, 03 May 2016 18:21:27 GMT

Sunny T

thanks already tried it but only gives me the number 1 in the whole list

Re: consecutive number

sunny_talwar — Tue, 03 May 2016 20:14:37 GMT

Would you be able to share a sample where it isn't working?

Re: consecutive number

Anonymous — Tue, 03 May 2016 20:31:20 GMT

Of course, with pleasure He puts the number 1 to the entire list of names

Re: consecutive number

moleroalonso — Tue, 03 May 2016 21:56:21 GMT

You can calculate the "No" column in the load script:

ORIGINAL_DATA:

LOAD * Inline

[

Grupo Corporativo, column1

Grupo4, something1

Grupo2, something1

Grupo3, something2

Grupo1, something1

Grupo1, something2

];

/*The [Grupo Corporativo] values are sorted and RowNo function generates the value of "No"*/

Left Join(ORIGINAL_DATA)

LOAD Distinct [Grupo Corporativo],

RowNo() as No

Resident ORIGINAL_DATA

Order by [Grupo Corporativo]

Re: consecutive number

sunny_talwar — Wed, 04 May 2016 00:57:57 GMT

by sample, I meant your qvw application.

Preparing examples for Upload - Reduction and Data Scrambling

Re: consecutive number

Anonymous — Wed, 04 May 2016 15:45:32 GMT

good day

stalwar1‌

Deputy qvw I hope can help me thanks greetings

Re: consecutive number

sunny_talwar — Wed, 04 May 2016 16:23:44 GMT

How about this?

Rank(Sum({1}TARIFA_NETA)) * Avg(1)

Re: consecutive number

Anonymous — Wed, 04 May 2016 16:31:51 GMT

stalwar1

thank you very much for your help served me pretty

greetings and good day a hug