Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
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
sunny_talwar

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