Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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; ')
Hi
Try like below
=num(Count({<[VRT Overall Status] ={'In Progress'}, Severity ={'Critical'} >}[Tracking ID]),'#,##0;-#,##0; ')
That worked...So cool! Thank you so much!!!
Hi
Try like below
=num(Count({<[VRT Overall Status] ={'In Progress'}, Severity ={'Critical'} >}[Tracking ID]),'#,##0;-#,##0; ')
That worked...So cool! Thank you so much!!!