Value in Quotes?

[prajapatiamar38]

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

[Kushal_Chawda · Accepted solution]

try,

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

[Anonymous]

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]

example script

x:

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

Inline

[

value

A

O

E

];

[qlikviewwizard]

Hi Please use as shown below.

[prajapatiamar38]

Thanks For your response its working fine.