Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression not working

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

11 Replies
Sokkorn
Master
Master

Hi Sunny,

Maybe you can try this

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

Not applicable
Author

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

Sokkorn
Master
Master

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

Not applicable
Author

Not working bro

sreenivas
Creator III
Creator III

can you post sample data

Sokkorn
Master
Master

Hi Sunny,

Can you attached your app?

Regards,

Sokkorn

jonathandienst

Hi

Just move the DISTINCT, its on the wrong place:

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

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

Thanks Jonathan  Its not working

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

senpradip007
Specialist III
Specialist III

Hi.

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

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