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'm looking to perform the following task in QV:
How can i achieve this ? I imagine there is a previous command involved. Just unsure as to how to frame the logic.
All suggestions are welcome. Thanks
if(Peek('New Column')<>Null(),Peek('New Column'),Null())& Value as [New Column];
LOAD * INLINE [
View solution in original post
May be like this
Alt(Peek('New Column'), '') & ',' & Value as [New Column]
My intentions were right, but I should have thought through or tested my code .
Peek('New Column') & Value & ',' as [New Column];
Left([New Column], Len([New Column]) - 1) as [New Column]
DROP Table Table;