Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Why is the filter ignored in set analysis

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,

VJ

1 Solution

Accepted Solutions
sunny_talwar

Try this

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

Implicit Set Operators

View solution in original post

2 Replies
sunny_talwar

Try this

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

Implicit Set Operators

Anil_Babu_Samineni

May be Implicit operator

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful