topic Re: Select in field button doesn't work? in QlikView

Select in field button doesn't work?

richnorris — Wed, 19 Mar 2014 17:27:52 GMT

If you create a button with a Select in Field function, and you set the values to values that exist, then it works fine. But we have restriction on section access, so for some uers, the values dont exist for them. The button is selecting 'France' 'Germany' and 'Spain', but some of the users do not have 'Germany'.

The button applies a number of actions, and for the users who don't have 'Germany' available, it just stops. It doesn't move on to the next actions, and it doesn't select 'France' or 'Spain' either. This seems a bit odd? Is there a way around this? A way to say, 'Select the following value if available'?

Re: Select in field button doesn't work?

jerem1234 — Wed, 19 Mar 2014 17:31:57 GMT

Maybe use the concat function like:

='(' & concat(distinct Country, '|') & ')'

or if you only want specific ones try:

='(' & concat({<Country = {'France', 'Germany', 'Spain'}>}distinct Country, '|') & ')'

Hope this helps!

Re: Select in field button doesn't work?

Wed, 19 Mar 2014 18:25:57 GMT

Jeremy's answer should work

If the set analysis still returns nothing, just try with a star to run a research:

='(' & concat({<Country = 'France*', 'Germany*', 'Spain*'}>}distinct Country, '|') & ')'

Fabrice

Re: Select in field button doesn't work?

richnorris — Thu, 20 Mar 2014 09:30:30 GMT

Thanks SO MUCH guys, this is a brilliant solution, of course set analysis can cope with non-existant values! It's very strange, because if we try with dummy data, (France|Spain|R'lyeh) It actually works fine with no fuss. It's only when we use Germany specifically in a section-access restricted set of values, where that value has been restricted, that we experience the issue.