Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
SkanderRadhouane
Contributor
Contributor

Calculate AVG days between two dates in Set Analysis

Hello Everyone,

So I have two dates, the first one is the day where a case is created and the second one is the end date.

What I would like to calculate, is a number where I can see how many days it take to the company to resolve a case.

 

Thank you and Have a nice day ! 

Labels (3)
1 Reply
vikasmahajan

create a variable using this

(date#('$(vCYEndDate)','DD/MM/YYYY')-date#('$(vCYStartDate)','DD/MM/YYYY')+1))

And use this in set analysis

 

Hope this helps you.

 

Vikas