Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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