topic Re: Chart Calculated Dimension Selection Not Affecting Count in QlikView

Chart Calculated Dimension Selection Not Affecting Count

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

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

Re: Chart Calculated Dimension Selection Not Affecting Count

sunny_talwar — Wed, 02 Aug 2017 17:06:04 GMT

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

Re: Chart Calculated Dimension Selection Not Affecting Count

Anonymous — Wed, 02 Aug 2017 17:25:00 GMT

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

Re: Chart Calculated Dimension Selection Not Affecting Count

sunny_talwar — Wed, 02 Aug 2017 17:38:07 GMT

Check here:

Implicit Set Operators

Re: Chart Calculated Dimension Selection Not Affecting Count

Anonymous — Wed, 02 Aug 2017 17:40:20 GMT

Thanks! This is super helpful and informative!

I really appreciate it.

Re: Chart Calculated Dimension Selection Not Affecting Count

sunny_talwar — Wed, 02 Aug 2017 18:06:46 GMT

No problem at all