topic Re: Field OnChange Trigger in QlikView

Field OnChange Trigger

Anonymous — Wed, 20 Aug 2014 19:23:07 GMT

I'm probably just over-thinking this, but I can't seem to make this work. I have a ListBox for a field called "Data Set" that allows the user to limit the data (from a large concatenated fact table) displayed in chart objects. There are only three options. The users can select any one of the values or the first two values at the same time. BUT...the third option can only be selected by itself. So I'm trying to get this trigger to detect if that third option has been selected and, if so, unselect the first two options (if either have been selected). Conversely, if either or both of the first two options is selected, the third is unselected. I hope that makes sense.

Re: Field OnChange Trigger

ecolomer — Wed, 20 Aug 2014 19:54:08 GMT

Hi,

I would propose the following idea:

First would group the first two options in a group on a list might only if the second choice is selected (previously third) group (now first choice) would no longer be selected. On the other hand if you select the group would open another list of options with the first two current

Do not know if I have explained and if it helps anything?

Saludos,

Enrique

Re: Field OnChange Trigger

ecolomer — Wed, 20 Aug 2014 20:02:10 GMT

An example

Re: Field OnChange Trigger

Anonymous — Wed, 20 Aug 2014 20:27:16 GMT

Thanks for the example. Not exactly what I'm after but workable if I can't figure out the trigger solution.

Re: Field OnChange Trigger

Anonymous — Wed, 20 Aug 2014 20:35:37 GMT

Document properties > Field Event Triggers > select "Data Set" (assuming that is your field name as shown in your post) > click Add actions for OnSelect > add Selection action to Select in Field > input [Data Set] for field name > input the following expression for Search String

=if(WildMatch(GetFieldSelections([Data Set]),'Operator*'),('Operator Sales'),'('&SubField(replace(getcurrentselections([Data Set]),', ', '|'),': ',2)&')')

Re: Field OnChange Trigger

Anonymous — Wed, 20 Aug 2014 21:11:11 GMT

That's really close jsaradhi. But it doesn't allow either of the first two options to be selected.

Re: Field OnChange Trigger

jagan — Thu, 21 Aug 2014 05:19:06 GMT

Hi,

Check this link hope it helps you.

Select in Field Trigger with Single or Multiple values

Regards,

Jagan.

Re: Field OnChange Trigger

jagan — Thu, 21 Aug 2014 05:20:33 GMT

Hi,

In your case it is

=if(WildMatch(GetFieldSelections([Data Set]),'Operator*'),('Operator Sales'),'("' & GetFieldSelections([Data Set], '"|"') & '")')

Hope this helps you.

Regards,

Jagan.

Re: Re: Field OnChange Trigger

Anonymous — Thu, 21 Aug 2014 14:35:56 GMT

modify the expression in my above post to the following (note the extra * in wildmatch and the 4 double quotes i added in the second part of the expression)

=if(WildMatch(GetFieldSelections([Data Set]),'*Operator*'),('Operator Sales'),'("'&SubField(replace(getcurrentselections([Data Set]),', ', '"|"'),': ',2)&'")')

Re: Field OnChange Trigger

Anonymous — Thu, 21 Aug 2014 15:16:36 GMT

Thanks jsaradhi! That seems to be working as I need it to.

Re: Field OnChange Trigger

Anonymous — Thu, 21 Aug 2014 15:18:08 GMT

Jagan, the link to that document says I'm not authorized to view.

Re: Field OnChange Trigger

Anonymous — Thu, 21 Aug 2014 15:21:23 GMT

As an FYI, it still doesn't behave properly if you use "Windows Checkboxes" as the Selection Style. It does seems to work if you use the "Classic" or "LED" style.

Re: Field OnChange Trigger

Anonymous — Thu, 21 Aug 2014 15:21:58 GMT

yeah...Jagan's response helped figure out that we need double quotes and i figured out the * in front of the text in wildmatch is needed...so thanks Jagan

Re: Field OnChange Trigger

Anonymous — Thu, 21 Aug 2014 15:24:32 GMT

yeah...i used classic style...the two checkbox styles (both windows and LED) behave slightly differently from the two styles without them...so i would use the ones that work

Re: Re: Re: Field OnChange Trigger

Anonymous — Thu, 21 Aug 2014 19:30:21 GMT

FYI

Using GetCurrentSelections proved to be problematic when other data selections were present so I changed the expression to the following, which seems to be working better.

=If(WildMatch(GetFieldSelections([Data Set]),'*Operator*'),('Operator Sales'),

replace('("' & GetFieldSelections([Data Set]) & '")',', ','"|"'))