Qlikview exclude action

[nickleshkevich]

Hi,

I had a problem

I have two sheets A and B, on the sheet A is the field C, if not selected any value in the field C, then going on a sheet of B must following condition holds - in the field C, select the value excluding "Value1" (not "Value1 "), if the value selected - leave the the selected value

[sunny_talwar · Accepted solution]

Try sheet level trigger on field C:

=If(GetSelectedCount(c) = 0, '(' & Concat({<c -= {'Value1'}>}DISTINCT Chr(34) & c & Chr(34), '|') & ')', '(' & Concat(DISTINCT Chr(34) & c & Chr(34), '|') & ')')

Attaching a sample for your review

[nickleshkevich]

Thank you so much! Work perfect!

[sunny_talwar]

Awesome