select in field

[marksmunich]

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.

[maxgro]

maybe with 2 actions:

select in field

select excluded

[marksmunich · Accepted solution]

Yeah got it.

Here is the soultion.

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

[tobias_klett]

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]

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

[tobias_klett]

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]

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