Discussion Board for collaboration on QlikView Scripting.
i've the following problem: i need to cover gaps in numerical sequences.
I've two fields, e.g., FIELD_C and FIELD_P:
So, i want this output:
Please, can you show me the right expression to do this?
probably this could work
NoConcatenateOUTPUT:LOADFIELD_C,If(FIELD_C<>Previous(FIELD_C), 1,If(FIELD_P<>Previous(FIELD_P),(Peek('FIELD_P')+1),Peek('FIELD_P'))) AS FIELD_P,FIELD_P AS FIELD_P_OLDResident ...Order ByFIELD_C,FIELD_P;
thanks for the prompt reply.
I try and i let you know ASAP!