Concatenate field value with prefix * and single quotes

[dhananjay_capge]

Hi there,

let's say I have a table like this

F1

A

B

C

need a expression in KPI box to show this result '*A','*B','*C' how to do this in QlikSense ?

Thanks in Advance.

DJ

[Taoufiq_Zarra]

Maye be :

=concat(chr(39)&'*'&F1&chr(39),',')

[NitinK7]

Hi,

try the following Expression

=Concat(chr(39) & '*' & F1 & chr (39), ',')

Thanks,

Nitin.