topic Re: Qlikview exclude action in QlikView

Qlikview exclude action

nickleshkevich — Wed, 27 Jul 2016 08:53:00 GMT

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

Re: Qlikview exclude action

sunny_talwar — Wed, 27 Jul 2016 09:52:57 GMT

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

Re: Qlikview exclude action

nickleshkevich — Wed, 27 Jul 2016 10:04:19 GMT

Thank you so much! Work perfect!

Re: Qlikview exclude action

sunny_talwar — Wed, 27 Jul 2016 10:08:48 GMT

Awesome