Hello Developers,
I am new bee to Qlikview. Got one requirement where the expression is something as below:
case
when TableA.ColumnA=0 then TableB.ColumnB
when TableA.ColumnA=1 then '....'||TableB.ColumnB
when TableA.ColumnA=2 then '.......'||TableB.ColumnB
else '...................'||TableB.ColumnB
end,
Here both case and concatenate functions are used.
How to write this in Qlikview script?
Any Suggestions?
Thanks in Advance
Savita