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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
prajapatiamar38
Creator II
Creator II

Value in Quotes?

Hi Experts,

I have one field In that the values are like A,O,E.....I want to see it as 'A','E','O'

How can i

Pls Suggest me

Thanks

1 Solution

Accepted Solutions
Kushal_Chawda

try,

=Concat(DISTINCT chr(39)&YourField&chr(39),',')

View solution in original post

5 Replies
Kushal_Chawda

try,

=Concat(DISTINCT chr(39)&YourField&chr(39),',')

Anonymous
Not applicable

Do you want it in alphabetic order? I would prefer do it inscript

tmpyourtable:

load

..

chr(39) & yourfield & chr(39) as yourfield

from ..

YourTable:

load *

resident tmpyourtable

order by yourfield asc; // you can skip asc as this is the Default order

drop table tmpyourtable

sasiparupudi1
Master III
Master III

example script

x:

load chr(39)&value&chr(39) as value

Inline

[

value

A

O

E

];

qlikviewwizard
Master II
Master II

Hi Please use as shown below.

Capture1.JPG

Capture2.JPG

prajapatiamar38
Creator II
Creator II
Author

Thanks For your response its working fine.