Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
ashmitp869
Creator
Creator

need help in expression

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

Labels (1)
  • Other

3 Replies
Maria_Halley
Support
Support

@ashmitp869

 

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

 

 

NitinK7
Specialist
Specialist

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