Chart Calculated Dimension Selection Not Affecting Count

[Anonymous]

Hi everyone,

I'm new to qlik and have finally stumbled into an error I can't seem to find already on this community (possible lack of terminology being an issue).

I've created a calculated dimension that says

     if((num1 = 100 AND num2 = 100 AND num3 = 100), 'Truly Equal', 'Other')

So if all my number fields are 100, then I have 'Truly Equal' in my chart. In my table I have 3 instances of this scenario, and then 1 instance where num1 is 80 and num2 and num3 are 100.

When I click on the bar that has 'Truly Equal' I get the 3 records that are indeed 100s, but then for my count of records >=64 and <100, I get 1. When I click that I get the 1 record I have that has num1 as 80 and num2 and num3 as 100.

Ideally my count for this particular selection would be 0. Why am I still getting that 1 record, and how can I resolve this?

Thanks in advance, I've attached the sample qlikview

[sunny_talwar · Accepted solution]

May be try selecting ID instead of direct selection id num1. PFA...

[Anonymous]

Thanks Sunny! What does *= mean exactly, in layman terms?

[sunny_talwar]

Check here:

Implicit Set Operators

[Anonymous]

Thanks! This is super helpful and informative!

I really appreciate it.

[sunny_talwar]

No problem at all