topic Re: need help in expression in QlikView

need help in expression

ashmitp869 — Wed, 17 Nov 2021 03:41:09 GMT

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 — Wed, 17 Nov 2021 08:22:41 GMT

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

NitinK7 — Wed, 17 Nov 2021 08:45:33 GMT

try once

Interval(

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

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

MarcoWedel — Wed, 17 Nov 2021 17:36:47 GMT

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')