Discussion board where members can get started with Qlik Sense.
I Load the sample data this way and want to get difference in the seconds how can i do this in script in place of this
Interval( [Close Date Time] - [Create Date Time], 'DD' ) want to get seconds difference in script and then average.
Interval( [Close Date Time] - [Create Date Time], 'DD' ) AS DiffDays
Now in front end just use
And calculate Average in bar chart this way.
Dim : Region
Expression :- Sum(DiffDays)/Count(Id)
Note:- Here my question is what is the unit of measurement of this average calculation in expression.
I attached the sample data.
Any one reply on this.
Use Seconds parameter like below:
Num#(Text#(Interval([Close Date Time] - [Create Date Time] , 's')))
The above purely convert interval value into string & then Num
( Num([Close Date Time]) - Num([Create Date Time]))*86400
I attached the sample data file please check.