Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kgeen
Contributor
Contributor

Expression to filter results in a gauge chart

Hi Everyone,

I've been trying to wrap my brain around this one. I'm using a series of gauge charts to measure time differences between two events.

Currently I have the expression to obtain the difference in minutes from the times

 

=Avg(Time((TimeB),'hh:mm:ss')*24*60 - Time((TimeA),'hh:mm:ss')*24*60)

 

`

 The other charts follow suite, TimeC-Time B, TimeD-TimeC etc

This shows are fairly accurate time average. However, I want to filter out dispositions so if a time falls into a certain category to ignore it from being used in the calculation of the chart without any selection. Below is a mockup of the table

DateDispositionTimeATimeBTimeC
06/01/2020A080009001000
06/01/2020B081519152015
06/01/2020C090010001100

 

Due to the nature of disposition B in the table, it's a different workflow that could skew the numbers i'm looking for. Therefore on the initial load of the page with these charts, looking for a way to not calculate that value. 

I know this code doesn't work, but this was my thought process on how this would work:

 

If(Not Match(Disposition,'B'),Disposition,null()) THEN AVG(Time((TimeB,'hh:mm:ss')*24*60 - Time((TimeA),'hh:mm:ss')*24*60)

 

 

Any help with this would be greatly appreciated!

0 Replies