topic Re: Value in Quotes? in QlikView

Value in Quotes?

prajapatiamar38 — Tue, 18 Aug 2015 06:15:41 GMT

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 — Tue, 18 Aug 2015 06:19:23 GMT

try,

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

Anonymous — Tue, 18 Aug 2015 06:30:01 GMT

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 — Tue, 18 Aug 2015 07:18:15 GMT

example script

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

Inline

[

value

];

qlikviewwizard — Tue, 18 Aug 2015 09:06:54 GMT

Hi Please use as shown below.

prajapatiamar38 — Wed, 19 Aug 2015 10:28:59 GMT

Thanks For your response its working fine.