need help in expression

[ashmitp869]

Hi there ,

I need the diff of two dates with where clause, pick the date when Triage category is 2,3 ?

Is this correct set analysis expression ?

Interval({<Triage Category ={2,3}>} KPIStartTime - ({<Triage Category ={2,3}>} FirstSeenTime,'mm')

[Maria_Halley]

@ashmitp869

I will move this to the App Development thread instead. I think you will get more answers there.

[NitinK7]

try once

Interval(

Aggr(Only({<Triage Category ={2,3}>} KPIStartTime),KPIStartTime) -

Aggr(Only({<Triage Category ={2,3}>} FirstSeenTime),FirstSeenTime) , 'mm')

[MarcoWedel]

Interval() does not take set expressions as it is no aggregation function.

Depending on your data and where you apply the expression maybe one of these could work for you:

Only({<Triage Category ={2,3}>} Interval(KPIStartTime - FirstSeenTime,'mm'))

Interval(Sum({<Triage Category ={2,3}>} KPIStartTime - FirstSeenTime),'mm')

see also:

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/Formatt...

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/ChartFunctions/Se...

hope this helps

Marco