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)