Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
max200560
Contributor II
Contributor II

Difference between date

Hi Guy. I'm new of the community. I've a problem that I believe is easy to solve. I've two column (date of invoice and date of contract) and I need to calculate the days between the two date. I put a column with misures and search between the function one for my work but I don't find anything. Can you help me? Thank you.....

Labels (1)
1 Solution

Accepted Solutions
melissapluke
Partner - Creator
Partner - Creator

Great! Would you mind clicking "Accept Response" so this question isn't shown as "unanswered"?  Thanks! Good luck with your app!

Melissa

View solution in original post

3 Replies
melissapluke
Partner - Creator
Partner - Creator

Hello,

You should be able to just add a column with the two dates. For example, in my data I have an "Audit Completed Date" and a "Cases Completed Date". I added a new measure column which takes [Audit Completed date]-[Cases Completed Date] and it calculates the result.

melissapluke_0-1614963902904.png

 

max200560
Contributor II
Contributor II
Author

Thank you. I resolved with the expression 

Cattura.JPG

melissapluke
Partner - Creator
Partner - Creator

Great! Would you mind clicking "Accept Response" so this question isn't shown as "unanswered"?  Thanks! Good luck with your app!

Melissa