Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

vlad_komarov
Valued Contributor III

Selecting field by Action with Conditions

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

Tags (2)
1 Solution

Accepted Solutions

Re: Selecting field by Action with Conditions

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.


talk is cheap, supply exceeds demand
2 Replies

Re: Selecting field by Action with Conditions

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.


talk is cheap, supply exceeds demand
vlad_komarov
Valued Contributor III

Re: Selecting field by Action with Conditions

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

Community Browser