Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

marksmunich
Contributor II

select in field

Hi Community,

in button properties, under Actions usually for multiple field selections we say

select in : field Name  for example field name is country

search string: (Canada|USA|australia)

What if I want to exclude These values values and select all other values in country.

Any suggestions.


Tags (1)
1 Solution

Accepted Solutions
marksmunich
Contributor II

Re: select in field

Yeah got it.

Here is the soultion.

Unbenannt.png

thanks Massimo grossi for quick reply.. I was trying everything and this worked out.


6 Replies
MVP
MVP

Re: select in field

maybe with 2 actions:

select in field

select excluded

marksmunich
Contributor II

Re: select in field

Yeah got it.

Here is the soultion.

Unbenannt.png

thanks Massimo grossi for quick reply.. I was trying everything and this worked out.


tobias_klett
Contributor II

Re: select in field

Hi,

use search string:

='('&concat({1<country=Country-{Canada,USA,australia}>} distinct Country,'|') & ')'

Note: If any country has a blank you need to use ' which is chr(39) to frame it in the result:

('South Korea'|'Germany')

Hope this helps

Tobias

marksmunich
Contributor II

Re: select in field

Thanks Tobias for the quick reply, I have used 2 Actions to solve this. . Select in field and select excluded.

tobias_klett
Contributor II

Re: select in field

Hi Marks,
that's fine. Just Keep watching your solution, because my experince is that QlikView is not very consistent on waiting for an Action before starting the next. Sometimes it seemed to me it is starting them almost at the same time which is not nice when the first Action hasn't calculated and the second which is depending on it starts already...

Tobias

marksmunich
Contributor II

Re: select in field

Thanks Tobias for the Suggestion. i will take a look into it.

Community Browser