Case and concatenation expression

[Anonymous]

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