Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Ron1
Partner - Creator
Partner - Creator

QlikSense Converting A table entries in quote and comma separated in script

I have a table loaded into my qlik app

XMas:

Dept

100,

101,

102,

103

etc

 

I want the output in below format,

'101','102','103'...etc

I am using chr(39) function, but it's giving me double quotes.. Can anyone please help

 

1 Reply
abhijitnalekar
Specialist II
Specialist II

Hi @Ron1 ,

 

Please check if this works for you 

= Concat( Dept ,''',''') &'''

Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!