Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
YG
Contributor III
Contributor III

Qlik Sense - COUNT Measure with multiple logic/filter implementation

Hey Qlikers,

I having an issue with measure setting logic as measure is validating but number are incorrect ,however when I deep dived the  measure it logically wrong, How I figured is by row numbers,

Measure 1 - Count( {<[Priority]={'1 - Critical','2 - High','3 - Moderate'}>} Incident_Number) = rows 255 (just all of the data in general)

Measure 2 - (Num(Count({<FYear_Num={$(=Max(FYear_Num))}>} Incident_Number), '##.00')) = rows 19583 (With a single Financial Year included)

However, below measure is Logically wrong

Measure 3 - (Num(Count({<FYear_Num={$(=Max(FYear_Num))}> +<[Priority]={'1 - Critical','2 - High','3 - Moderate'}>} Incident_Number), '##.00')) - rows 19,763 (Combination of Measure 1 and 2)

why I am saying that is that number should be Below<255 for just 1 Financial year

But I am getting as per Measure 3 = 19,763

Clearly the issue is with Measure 3 but i dont get how its wrong. Anyone cal help would be really appreciated. Thanks 

Labels (2)
0 Replies