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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.