Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I'm new in qlikview and i have a doubt:
I have a field named Status and i have 3 distinct values (O, C, R), so i need to join O + R and give a name 'Open'. But i need to isolate Status as Open with just Open too. This is the script i have:
If(STATUS = 'O', 'Open', If(STATUS = 'C', 'Close', 'Reopen')) as Status
thanks
In Status field i only have values 'O' (Open), 'R' (Reopen) and 'C' (Closed)
If status is O or R so it's 'Open' but if it's only R it need to be named as 'Reopen'
Try like this : Create an new field with the inline load that should take care
LOAD * inline
[
Status , New_Status
O,Open
R,Open
R,Reopen
C,Closed
];
Now use the New_Status field that will server the purpose