topic Re: Concat-Expression in QlikView

Concat-Expression

Mon, 14 Oct 2013 07:57:07 GMT

Hello community,

i have one question.

I have a tablewith a colum "test" with the values apple, orange, salad.

i want to concate them like this :

'apple', 'orange', 'salad'.

the function concat(test,',') ist not enough. the apostrophe ist missing.

can someone help me please?

thanks a lot!

best regards,

Aylin

Re: Concat-Expression

CELAMBARASAN — Mon, 14 Oct 2013 08:01:14 GMT

You could use like

Chr(39) & concat(test, Chr(39) & ',' & Chr(39)) & Chr(39)

Re: Concat-Expression

MayilVahanan — Mon, 14 Oct 2013 08:02:15 GMT

Try like this

Load Chr(39)&Replace(B,',',Chr(39)&','&Chr(39))&Chr(39) As B;

Load Concat(DISTINCT A,',') as B;

Load * Inline

[

apple

orange

salad

];

Re: Concat-Expression

Mon, 14 Oct 2013 08:07:06 GMT

Try,

='`'& concat(Left([year-month],4),'`,`')&'`'

Re: Re: Concat-Expression

Mon, 14 Oct 2013 08:12:32 GMT

Hi thanks for your answer. i testet it but the expression returns a 0 instad of a 1.

mixMatch('orange',B)

Re: Re: Concat-Expression

Mon, 14 Oct 2013 08:14:47 GMT

HI thanks for your answer. i tried this but my expressions returns a 0.

mixMatch('orange',Chr(39) & concat(test, Chr(39) & ',' & Chr(39)) & Chr(39)

)

Re: Concat-Expression

CELAMBARASAN — Mon, 14 Oct 2013 08:17:02 GMT

You could use

=WildMatch(B, '*orange*')

Because MixMatch matches the whole word.

Re: Re: Concat-Expression

Mon, 14 Oct 2013 08:29:49 GMT

i can't use wildmatch. because i have to search for the whole word. how can i do this with mixmatch ?

Re: Concat-Expression

Mon, 14 Oct 2013 08:44:51 GMT

I solved it:

WildMatch(B, chr(42)&'orange'&chr(42))

Thanks all for your help#!