topic expression help in QlikView

expression help

surajap123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

The below expression doesn't work when there is space in the value.

eg- United States.

But works for all other values, eg- India, France, UK etc.

IF(GetSelectedCount(Country),'('&Concat(DISTINCT Country,'|') & ')','')

Please note that i have onSelect Trigger in the document settings. Here is the attached app. The purpose of trigger is to select fields that are unlinked.

Please help.

Re: expression help

effinty2112 — Tue, 18 Jul 2017 08:32:25 GMT

Hi Suraj,

Aren't we missing something in the condition?

Perhaps:

IF(GetSelectedCount(Country) > 0 ,'('&Concat(DISTINCT Country,'|') & ')','')

Should still work for Countries with spaces in the name.

Cheers

Andrew

Re: expression help

antoniotiman — Tue, 18 Jul 2017 08:33:20 GMT

Hi,

try

IF(GetSelectedCount(Country),'('&Concat(DISTINCT Chr(39)&Country&Chr(39),'|') & ')','')

Re: expression help

effinty2112 — Tue, 18 Jul 2017 08:34:33 GMT

Hi Suraj,

Are you using the result as a search filter?

Andrew

Re: expression help

surajap123 — Tue, 18 Jul 2017 08:43:20 GMT

Thanks for all the replies.

I have attached a sample app. I want the selections to happen on other field through Trigger.

This is just to connect both fields that are not linked by tables.

Re: expression help

effinty2112 — Tue, 18 Jul 2017 08:47:14 GMT

Suraj,

Here's a workaround that might work:

=IF(GetSelectedCount(Country) > 0 ,'('& replace(Concat(DISTINCT Country,'|'),' ','?') & ')','')

found this in the forum from two years ago by a chap called Neil Miller so credit to him if it works.

Cheers

Andrew

Re: expression help

surajap123 — Tue, 18 Jul 2017 08:57:06 GMT

Thank you so much for your help Andrew.