topic How to conditionally trigger an action in QlikView

How to conditionally trigger an action

Mon, 14 May 2012 12:42:50 GMT

Hi,I have a list box called AcademicYearofEntry on a tab. I want to pre-select a specific value in this list box when opening the tab. This I can do via a Select in Field action triggered on activating the tab (or by a bookmark action). However I actually only want that default list box value to be selected if a value for this field has not already been selected on a different tab. If a value has already been selected on a different tab then instead I want that value to be carried across to the list box on the second tab.

Can anyone help?

P.S. I cannot check the 'Always One Selected Value' checkbox on the listbox as the listbox is actually an expression based on the field.

Thanks

Re: How to conditionally trigger an action

jagannalla — Mon, 14 May 2012 13:06:25 GMT

Hbutters,

Try the attached file. I written OnActivateSheet Trigger for sheet1 please check it. Hope it helps you.

How to conditionally trigger an action

Jason_Michaelides — Mon, 14 May 2012 13:11:15 GMT

In your Select in Field action try:

IF(GetSelectedCount(YourField)=0,'YourRequiredValue')

Hope this helps,

Jason

How to conditionally trigger an action

Mon, 14 May 2012 13:37:00 GMT

Hi, this is what I had tried but it did not appear to work and I am not sure if it is due to me having an expression as the basis for the list box field.

How to conditionally trigger an action

Jason_Michaelides — Mon, 14 May 2012 13:44:12 GMT

That would probably explain it. What's the expression?

Re: How to conditionally trigger an action

Mon, 14 May 2012 13:45:50 GMT

=if (match(AcademicYearofEntry,'2010-11','2011-12','2012-13')>0,AcademicYearofEntry)

How to conditionally trigger an action

Jason_Michaelides — Mon, 14 May 2012 13:57:42 GMT

Hmm. I can't test it now but if you select a value in that listbox I think it should make the selection in the AcademicYearofEntry field so it should work. Are there any other actions/triggers that might be removing selections in this field?

Re: How to conditionally trigger an action

Mon, 14 May 2012 14:51:50 GMT

Hi that actually seems to work now sorry –I did not have the inverted commas around the fieldname. However now I wanted to do the same code/action on the other tab and it is having none of it! Thanks anyway.