topic Selecting field by Action with Conditions in QlikView

Selecting field by Action with Conditions

vlad_komarov — Fri, 29 Mar 2013 16:38:26 GMT

Hello!

I need to select a field's value by using actions, but it does not work the way I hope.

Here is the scenario (a bit complicated).

I have multiple tabs and I am using variables to identify them:

I have a variable that changes when different page is activated. OnChange event for this variable I am calling the following Action:

1. [Select in Field] -->Field Name = [Agreement Type]

Search String = if ('$(vLevel_View_Current)' = '$(vLevel_View_3_Name)', 'Miscellaneous', Null())

2. [Select Excluded]-->Field Name = [Agreement Type]

The idea is to select ALL, but 'Miscellaneous' values in [Agreement Type] field when user switches to vLevel_View_3_Name tab.

It works but with one problem:

If any other field have the selected value, the application selects associated values in the [Agreement Type] field when I am selecting any other but vLevel_View_3_Name tab.

I am guessing the Null() in SearchString formula above causes this, but I was not able to find any other option to fulfill the above requirement.

Is there any option that could work for me with the above condition?

I would appreciate your comments and/or suggestions.

Best regards,

Vladimir

Re: Selecting field by Action with Conditions

Gysbert_Wassenaar — Fri, 29 Mar 2013 19:28:15 GMT

It's not because of the nulls. Nulls can't be selected. It's because of the selections in other fields. The Select Excluded only selects values that are possible given the selections in other fields. That's not what you want apparently. Try adding a Clear All action before the Select in Field action.

Re: Selecting field by Action with Conditions

vlad_komarov — Sat, 30 Mar 2013 11:36:08 GMT

Thanks, it works when I've added a ClearAll call.

The only concern is that it clears all filters when switching between pages, which kind of goes against QV idea of Associative Selection....

Regards,

Vladimir