To calculate avg() for the Expression

[Sai_Mohan]

Hi All,

I am new to qlik sense. I have one expression and i am trying to calculate average for that. Please help me with that.

Expression:

IF(MATCH(Status,'Active'),'NA',    REPLACE(REPLACE(REPLACE(REPLACE(
INTERVAL(TIME(EndDate, 'd:hh:mm:ss') - TIME(Begindate, 'd:hh:mm:ss'), 'd!hh@mm#ss$')
,'!','d : '),'@','h : '),'#','m'),'$','s')

Thanks In Advance! 

Sai

[JustinDallas]

It's not quite clear what you want to AVG().  In any case, I would do all the ...REPLACE(REPLACE(REPLACE.. in my data load and not in my dimension or measure.

[Sai_Mohan]

Hi @JustinDallas 

Thanks for replying!

I got solution for that.

Thanks 

Sai