Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be try selecting ID instead of direct selection id num1. PFA...
May be try selecting ID instead of direct selection id num1. PFA...
Thanks Sunny! What does *= mean exactly, in layman terms?
Check here:
Thanks! This is super helpful and informative!
I really appreciate it.
No problem at all