topic Re: select in field in QlikView

select in field

marksmunich — Tue, 23 Sep 2014 14:46:33 GMT

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.

Re: select in field

maxgro — Tue, 23 Sep 2014 14:50:56 GMT

maybe with 2 actions:

select in field

select excluded

Re: select in field

marksmunich — Tue, 23 Sep 2014 14:54:54 GMT

Yeah got it.

Here is the soultion.

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

Re: select in field

tobias_klett — Tue, 23 Sep 2014 14:59:53 GMT

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

Re: select in field

marksmunich — Tue, 23 Sep 2014 15:02:58 GMT

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

Re: select in field

tobias_klett — Tue, 23 Sep 2014 15:38:38 GMT

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

Re: select in field

marksmunich — Wed, 24 Sep 2014 11:48:36 GMT

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