Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Condition based on time between 2 dates in measure

Hi All,

My requirements is show bar chart based on time difference between 2 dates.

2 dates are RequestDate and AcceptDate. Calculate the time difference between 2 dates. Show count in bar chart accept within 2 hour, between 2 to 4 hour, between 4 to 8 hour, between 8 to 24 hour etc. Please explain what measure expression i've to used display bar chart. Please see the attached for example.Image1.jpg based on request

Thanks in advance

Regards,

Ankit Singh

2 Replies

Re: Condition based on time between 2 dates in measure

May be this link might help

Buckets

Not applicable

Re: Condition based on time between 2 dates in measure

Sunny can we divide one bar block in multiple color with count of group by ?