Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor II

Qlikview exclude action

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

Tags (3)
1 Solution

Accepted Solutions
Highlighted

Re: Qlikview exclude action

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

View solution in original post

3 Replies
Highlighted

Re: Qlikview exclude action

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

View solution in original post

Highlighted
New Contributor II

Re: Qlikview exclude action

Thank you so much! Work perfect!

Highlighted

Re: Qlikview exclude action

Awesome