topic Re: How to identify that field have multiple values selected in QlikView

How to identify that field have multiple values selected

Mon, 11 Apr 2016 11:20:18 GMT

I've a field named Day;

And I've 5 buttons with an action "Alter Selection"

I have 5 buttons:

Monday
- Alter Selection -> W_Day = ‘M’
Thursday
- Alter Selection -> W_Day = ‘T’
Wednesday
- Alter Selection -> W_Day = ‘W’
Tuesday
- Alter Selection -> W_Day = ‘Tu’
Friday
- Alter Selection -> W_Day = ‘F’

I want now that my buttons change it colour based on selection. For example, for the first button I'm trying:

=IF(MATCH(Day,'M') ,RGB(0,0, 0), RGB(255, 255, 255))

If I only have the value 'M' selected, it works fine but I select other values it changes... I already try with Day = ('M' | 'T') but it do what I want...

Re: How to identify that field have multiple values selected

Chanty4u — Mon, 11 Apr 2016 11:21:58 GMT

did u try

=IF(MATCH(Day,'M','T','W','Tu','F') ,RGB(0,0, 0), RGB(255, 255, 255))

Re: How to identify that field have multiple values selected

sunny_talwar — Mon, 11 Apr 2016 11:22:50 GMT

Try this:

=If(SubStringCount(Concat(DISTINCT '|' & Day & '|'),'|M|') = 1, RGB(0,0, 0), RGB(255, 255, 255))

Re: How to identify that field have multiple values selected

Gysbert_Wassenaar — Mon, 11 Apr 2016 11:23:37 GMT

Try =if(max(match(Day, 'M')), RGB(0,0, 0), RGB(255, 255, 255))