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: 
Not applicable

Average

Hi

     

MARAACTION=ALT1=ACT1=Different
150331SCBLAEADBXXX0724513017HOLD3/31/2015 1:40:19 PM4/1/2015 4:04:24 AM14:24:05
150331SCBLAEADBXXX0724513017CANCEL3/31/2015 1:40:19 PM4/1/2015 10:36:57 AM20:56:38
150331SCBLAEADBXXX0724513018HOLD3/31/2015 1:30:19 PM4/1/2015 4:04:24 AM14:34:05
150331SCBLAEADBXXX0724513018OK3/31/2015 1:41:19 PM4/1/2015 10:36:57 AM20:55:38

Graph should display the Average Different for the MAR Number with the AACTION as OK, CANCEL only

Average should be 20:56

Thanks

1 Reply
tresesco
MVP
MVP

Dimension: MAR

Exp: Avg( {<AACTION={'OK', 'CANCEL'}>} Different)