-
Re: Match + string variable in set analysis
pradosh thakur Dec 24, 2017 6:34 AM (in response to Linoy Elias)try this
=If(match(Business, $(=vRelevantBusinesses)), Business)
-
Re: Match + string variable in set analysis
Linoy Elias Dec 24, 2017 6:40 AM (in response to pradosh thakur)Thanks, but no, that doesn't work either.
-
Re: Match + string variable in set analysis
pradosh thakur Dec 24, 2017 6:51 AM (in response to Linoy Elias)try
chr(39) & concat(distinct Business,chr(39)&','&chr(39)) & chr(39) as varibale
-
Re: Match + string variable in set analysis
Linoy Elias Dec 24, 2017 7:01 AM (in response to pradosh thakur)Your variable is great and it returns the same output which is 'a','b','c'
The problem is when using this variable in match function
-
Re: String variable in match function in expression
pradosh thakur Dec 24, 2017 7:13 AM (in response to Linoy Elias)which object are you using this expression? if possible post a sample.
-
Re: String variable in match function in expression
Linoy Elias Dec 24, 2017 7:30 AM (in response to pradosh thakur)Bar chart
-
Re: String variable in match function in expression
pradosh thakur Dec 24, 2017 7:26 AM (in response to Linoy Elias)please post a sample. working for me when i am trying in my app.
-
Re: String variable in match function in expression
Linoy Elias Dec 24, 2017 7:30 AM (in response to pradosh thakur)I've attached the sample to the initial posting, thanks
-
Re: String variable in match function in expression
pradosh thakur Dec 24, 2017 7:52 AM (in response to Linoy Elias)pfa
=chr(39) & concat(distinct Business,chr(39)&','&chr(39)) & chr(39) as variable.
https://community.qlik.com/blogs/qlikviewdesignblog/2014/11/24/the-equal-sign
a good read
regards
Pradosh
-
TempApp.qvf 176.0 K
-
Re: String variable in match function in expression
Linoy Elias Dec 24, 2017 9:59 AM (in response to pradosh thakur)Thanks, that's worked
-
-
-
-
-
-
-
-
-
-
Re: String variable in match function in expression
Sunny Talwar Dec 24, 2017 7:49 AM (in response to Linoy Elias)Try this
=If(match(Business, $(=$(vRelevantBusinesses))), Business)
-
TempApp.qvf 176.0 K
-
Re: String variable in match function in expression
Sunny Talwar Dec 24, 2017 7:51 AM (in response to Sunny Talwar )Or you can use an equal sign with your variable like this
=chr(39) & concat(distinct Business,chr(39)&','&chr(39)) & chr(39)
and then this
=If(match(Business, $(=vRelevantBusinesses)), Business)
-
TempApp.qvf 176.0 K
-
Re: String variable in match function in expression
Linoy Elias Dec 24, 2017 10:00 AM (in response to Sunny Talwar )Thank you!
-
-