consecutive number

[Anonymous]

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

[sunny_talwar]

Can you try this:

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

[Anonymous]

hi

Sunny T

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

[sunny_talwar]

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

[Anonymous]

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

[moleroalonso]

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]

[sunny_talwar]

by sample, I meant your qvw application.

Preparing examples for Upload - Reduction and Data Scrambling

[Anonymous]

good day

stalwar1‌

Deputy qvw I hope can help me thanks greetings

[sunny_talwar · Accepted solution]

How about this?

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

[Anonymous]

stalwar1

thank you very much for your help served me pretty

greetings and good day a hug