topic Re: Determine if a value is currently selected? in QlikView

Determine if a value is currently selected?

scotthan — Mon, 02 Apr 2012 20:28:17 GMT

Hi,

I am trying to determine if a month is currently selected. I am breaking an example down as much as possible to the point where the problem is. See the expression:

match('ValueInQuestion',getFieldSelections(SampleField))

If I select ValueInQuestion as the only selection in the field SampleField, this function returns 1 as I would expect. However, if I select two values in the field SampleField, then I get 0 even if 'ValueInQuestion' is also selected.

What is the proper way to do this? More relevant to my situation, I am trying to determine if a certain month is selected, such that I can do match('Apr',getFieldSelections(Month)) and have that return some number that is > 0 when I have a bunch of months selected.

Thanks!

Determine if a value is currently selected?

swuehl — Mon, 02 Apr 2012 20:41:21 GMT

You should be able to use something like

=wildmatch(GetFieldSelections(FieldName),'*ValueInQuestion,*')

Remember that the GetFieldSelections() functions will only show a certain amount of values in clear text (use the third parameter to increase the number).

And I think there might be a more simple approach, too, but just can't get it right now.

Hope this helps,

Stefan

Determine if a value is currently selected?

scotthan — Mon, 02 Apr 2012 20:52:31 GMT

Thanks so much, I never thought to put the GetFieldSelections as the first parameter. Very creative!

My final expression is wildmatch(getFieldSelections(Month,','),'*'&Month(today())&'*')

Re: Determine if a value is currently selected?

dgreenberg — Tue, 14 Nov 2017 00:10:04 GMT

What if there could be two values:

I this example I am creating a field picker fro a report so I display a list of fields created by an inline table.

Then I build out the straight table chart and conditionally enable/disable the fields with an expression.

Topic

Sub Topic

Client Name

I want to check if Topic is selected but with your example if Sub Topic is selected it will also return a 1.

I have tried things like

=index(GetFieldSelections(%Fieldz2,'|',100),'Topic')

=wildmatch(GetFieldSelections(%Fieldz2,';',2000),'*Topic*')

=index(GetFieldSelections(%Fieldz2,'|',1000),'Topic')

So far the only thing I have working is ugly and that's to change it from Topic to Topic_ that therefore has a unique string.

Any suggestions?

Re: Determine if a value is currently selected?

dgreenberg — Tue, 14 Nov 2017 00:15:40 GMT

Far to often as soon as I type out a question I come up with the answer but still thankful the forum helps me do that.

This is how I resolved it.

Instead of

=wildmatch(GetFieldSelections(%Fieldz2,';',2000),'*Topic*')

I used

=wildmatch(GetFieldSelections(%Fieldz2,';',2000),'*;Topic;*') including the delineater ; before and after now only Topic returns a 1 Topic Group and Sub Topic do not.

Re: Determine if a value is currently selected?

dgreenberg — Tue, 14 Nov 2017 12:15:37 GMT

Actually I tweaked it some more as if it were the first or last value in the string it may not match.

Now I use this:

=wildmatch(('|' &concat(DISTINCT GetFieldSelections(%Fieldz2,'|')) &'|'),'*|Topic|*')

Re: Determine if a value is currently selected?

piter89 — Thu, 04 Jul 2024 09:35:31 GMT

I use this solution in my app:

wildmatch('#' & GetFieldSelections([Field], '#') & '#','*#Topic#*')