how to incorporate comma by using expression - Qlik Community

nagarjuna005 · ‎2018-10-04

Hi Everyone,

I have four fields like DESC1,DESC2,DESC3,DESC4

i have concated by using below expression when i have single service code like 001

concact(DESC1&DESC2&DESC3&DESC4)

so now i want to put comma after desc4 when i have more than single service codes like 001,002,003

how to write in expression can anyone help thanks!

Anil_Babu_Samineni · ‎2018-10-04

May be try this?

Concact(DESC1&DESC2&DESC3&DESC4, ',')

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

nsetty · ‎2018-10-04

=DESC1&','&DESC2&','&DESC3&','&DESC4