Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!