This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have such data, and must make 'Reference' field in such manner:
Add reference field:
*table is ordered by Seq ASC.
[Must add "Reference" field]
Would you possibly advise how we would achieve such load?
If(Type='A',Value,Peek('Ref',-1)) AS Ref
Should work for you
Hopet hat helps
View solution in original post
Type, Seq, Value
A, 1, 1
B, 2, 21
B, 3, 22
D, 4, 23
A, 5, 5
B, 6, 39
A, 7, 7
C, 8, 54
LOAD *, if(Type = 'A', Value, Peek(Ref)) AS Ref
DROP Table T1;
if(Type='A',Value, peek(Ref)) as Ref
Thank you for quick answer. It works.
Dear Gysbert, thank you for the fast reply as usual. It works!
Thank you Joe for fast reply. It is working, and you are the first reply.
no problem, glad to help