Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Guilgo
Partner - Contributor III
Partner - Contributor III

Difference between 2 dates and group in a graph

Hello, 

 

I need to make a difference between 2 dates fields "StartDate" and "EndDate" but the formula "EndDate - StartDate" doesn't work. 

 

I need also to group my result, the result of the difference will be between 0 and 2000 and i would like an easy to read bar chart. For exemple an absciss with [0-30] [30-60] [60-90] days .... Is it possible to do that ? 

 

Thank you ! 

Labels (5)
3 Replies
Or
MVP
MVP

EndDate - StartDate should work (assuming they're both dates).

You can use the Class() function or nested if() statements to generate groupings.

Guilgo
Partner - Contributor III
Partner - Contributor III
Author

thank you I've calculated the difference of dates

 

But but for value groups I've managed to group by value, for example '0-50' '50-100' and '100+' with nested if

 

However, I'd like to have a real hierarchy, for example I click on '0-50' and I get a filter on field values between 0 and 50. Is this possible?

Guilgo
Partner - Contributor III
Partner - Contributor III
Author

up