Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
Showing results for 
Search instead for 
Did you mean: 
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 

0 Replies