Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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!