topic Re: Why is the filter ignored in set analysis in QlikView

Why is the filter ignored in set analysis

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Helo,

I am doing a count of a field f4 for a specific value of field f2 with this code =count({<f2={'b2'}>} distinct f4)

With nothing selected in f2, this gives result as 1, which is fine.

When I select f2=b1, I was hoping this code will give 0 but it still gives 1.

Why is it ignoring the f2=b1 selection? How can I make it consider that selection?

Thanks,

sunny_talwar — Wed, 20 Dec 2017 14:00:31 GMT

Try this

=Count({<f2 *= {b2}>} distinct f4)

Implicit Set Operators

Anil_Babu_Samineni — Wed, 20 Dec 2017 14:02:23 GMT

May be Implicit operator