topic Expression Issue/Please Help! :) in QlikView

Expression Issue/Please Help! :)

Matt_M1 — Wed, 17 Nov 2021 22:16:30 GMT

Hey All,

I'm relatively new to Qlikview and can't figure this out.

What I'm trying to do is get a count of the Tracking ID, but filter on two things...the first being the VRT Overall Status being 'In Progress'. The expression below works, but I can't get the second filter added in. I also want to filter on Severity being 'Critical'. Could someone...anyone...please help me get that added into the below expression?

=num(Count({<[VRT Overall Status] ={'In Progress'} >}[Tracking ID]),'#,##0;-#,##0; ')

Re: Expression Issue/Please Help! :)

MayilVahanan — Thu, 18 Nov 2021 07:36:30 GMT

Try like below

=num(Count({<[VRT Overall Status] ={'In Progress'}, Severity ={'Critical'} >}[Tracking ID]),'#,##0;-#,##0; ')

Re: Expression Issue/Please Help! :)

Matt_M1 — Thu, 18 Nov 2021 12:29:40 GMT

That worked...So cool! Thank you so much!!!