Skip to main content
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Expression with condition inside

Hi, all,

I meet a problem in set expression. I would like to write conditions in the set expression. Could anyone help me out?

The problem is: I have set expression here {1<field_A={'A','B'}>}. I need to create a button to do Toggle Selection on field_B. Once I click on the button, the set expression should be {1<filed_C = {'X','Y'},field_A={'A','B'}>} (No typo here, the revised part is on field_C not field_B)

I think maybe this can be done by GetFieldSelections(Field), But I am kind of confused on the gramma inside the set expression.

Thank you!

1 Reply

May be create two expressions selected based on selection in field_b

If(GetSelectedCount(field_B) > 0, {1<filed_C = {'X','Y'},field_A={'A','B'}>}, {1<field_A={'A','B'}>})

I only added the set analysis, but make sure to add the complete expressions