Case and concatenation expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

topic Case and concatenation expression in QlikView