topic Re: Expression not working in QlikView

Expression not working

Wed, 05 Feb 2014 05:54:25 GMT

Hi All,

Can anyone please tell me whats wrong in the below expression?

1 I created a varible

vcity =concat(DISTINCT {<city={"delhi"}>}Id,',')

and its working fine and giving the correct result if i use it in textbox like this =$(vcity) . It returns result like 1,2,3

now i am trying to use the above varible in the expression below but here its not working. Can some please help me on this?

=CONCAT(DISTINCT {<Id={"=$(vcity)"}>} saleperson,',')

Thanks a lot

Re: Expression not working

Sokkorn — Wed, 05 Feb 2014 06:09:04 GMT

Hi Sunny,

Maybe you can try this

=CONCAT(DISTINCT {<Id={"=vcity"}>} saleperson,',')

Re: Expression not working

Wed, 05 Feb 2014 06:23:50 GMT

Hi Sikkorn,

Its not working

Also I was trying to add CONCAT(DISTINCT {<Id={"=$(vcity)"}>} saleperson,',') expression in char (calculated dimensions) but i dont think it will work like this

Re: Expression not working

Sokkorn — Wed, 05 Feb 2014 06:26:03 GMT

How about this one CONCAT(DISTINCT {<Id={"$(=vcity)"}>} saleperson,',')

Re: Expression not working

Wed, 05 Feb 2014 06:32:58 GMT

Not working bro

Re: Expression not working

sreenivas — Wed, 05 Feb 2014 06:40:11 GMT

can you post sample data

Re: Expression not working

Sokkorn — Wed, 05 Feb 2014 06:41:19 GMT

Hi Sunny,

Can you attached your app?

Regards,

Sokkorn

Re: Expression not working

jonathandienst — Wed, 05 Feb 2014 06:42:55 GMT

Just move the DISTINCT, its on the wrong place:

=CONCAT({<Id={"=$(vcity)"}>} DISTINCT saleperson,',')

HTH

Jonathan

Re: Expression not working

Wed, 05 Feb 2014 06:46:09 GMT

Thanks Jonathan Its not working

I tried. Thank you all I will upload a sample data soon

Re: Expression not working

senpradip007 — Wed, 05 Feb 2014 06:53:36 GMT

Hi.

Variable vcity =concat(DISTINCT {<city={"delhi"}>}Id,',')

Concate({<id = {$(vcity)} >} distinct salesperson, ',')

Re: Expression not working

sudeepkm — Wed, 05 Feb 2014 06:57:28 GMT

This is surprising that the variable carrying the same info is not working inside the set analysis.

As a workaround you may write your expression like below.

=Concat(DISTINCT {< ID={$(=concat(DISTINCT {<City={'delhi'}>}ID,',')) } >} salesperson)

Re: Expression not working

jonathandienst — Wed, 05 Feb 2014 07:14:31 GMT

Remove the = sign in the set expression, assuming vcity contains a string:

=CONCAT({<Id={'$(vcity)'}>} DISTINCT saleperson,',')

HTH