Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vlad_komarov
Partner - Specialist III
Partner - Specialist 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

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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

View solution in original post

2 Replies
Gysbert_Wassenaar

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
Partner - Specialist III
Partner - Specialist III
Author

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