Expression Issue/Please Help! :)

[Matt_M1]

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; ')

[MayilVahanan · Accepted solution]

Hi

Try like below

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

[Matt_M1 · Accepted solution]

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