topic Re: search a value in a Multiple selection in QlikView

search a value in a Multiple selection

Mon, 20 Apr 2015 15:25:14 GMT

Hi, I have a problem with qlikview.

I have a calendar that I can select multiple values for month. I need to know if when I have selected several months March is selected.

For example:

If ('March' IN selected-months, then condition)

I tried with Match function but this only works if you select only one month.

Any ideas?

Thanks!

Re: search a value in a Multiple selection

sunny_talwar — Mon, 20 Apr 2015 17:00:49 GMT

You may need to use Subfield function when you have multiple months. But the exact expression which can be used can only be determine once you share a sample data or application.

Best,

Sunny

Re: search a value in a Multiple selection

jonathandienst — Mon, 20 Apr 2015 17:06:03 GMT

In expression:

=If(WildMatch(GetFieldSelections(Month), '*March*'), 1, 0)

Flow control in script:

If WildMatch(GetFieldSelections(Month), '*March*') Then

HTH

Jonathan

Re: search a value in a Multiple selection

Anonymous — Mon, 20 Apr 2015 18:15:48 GMT

Jonathan, it is not a script function...

Re: search a value in a Multiple selection

ramoncova06 — Mon, 20 Apr 2015 21:32:59 GMT

use substringcount inside of a concat

if(SubStringCount(Concat('||' & 'Month, '||'), '||March||') >0 and GetSelectedCount(Month) > 0,

Re: search a value in a Multiple selection

Anonymous — Mon, 20 Apr 2015 23:44:26 GMT

Try this,

if(SubStringCount(getfieldselections(urmonthfield),'March')>0, then condition)

Re: search a value in a Multiple selection

Anonymous — Mon, 20 Apr 2015 23:45:21 GMT

considering you would want to do it in the front-end.

Re: search a value in a Multiple selection

Tue, 21 Apr 2015 08:03:30 GMT

Thanks for all, I tried:

=substringcount(concat(DISTINCT Mes),'mar')

And it´s works perfectly

Re: search a value in a Multiple selection

anbu1984 — Tue, 21 Apr 2015 08:20:50 GMT

If (Index(GetFieldSelections(MonthField), 'March'), 'Present','Not')

If (GetFieldSelections(MonthField) Like '*March*', 'Present','Not')

Re: search a value in a Multiple selection

Anonymous — Tue, 21 Apr 2015 11:45:27 GMT

There is a difference between using concat() and GetFieldSelections(). If you use concat(), it would react on all available values, not just selected values - which is not the same. Your request was about the selected values, so concat() is not the right function for this requirement. Well, if it works for you - you know better what's really required.

Second, the correct answers was given by Jonathan (if use GetFfieldSelections) and by Ramon (if use concat). They deserve at least "helpful" points. Marking your own answer as correct is fine of course, especially if there were no other good answers, but it doesn't add you points anyway.

Re: search a value in a Multiple selection

ramoncova06 — Tue, 21 Apr 2015 14:23:59 GMT

Michael is right concat and getfieldselections are similar but no the same, the reason I prefer to use concat over getselections is because I can massage the values to the format want, so if I am looking for a result called Inventory, but in my selections I have Inventory and Warehouse inventory I can still separate them

"and GetSelectedCount(Month) > 0" this part of the expression makes sure that this only works when this field is selected, otherwise the concat will bring you all the values