Date Range

[#1]

Hi Experts,

i have an Employee details table which has Startdate as a dimension.

from this, i have done the calendar to get month and year of start date.

i have done an expression as Date(Today())-STARTDATE to calculate the length of service in days.

i have the following chart to count the no. of employees with regard to length of service.

Now i need to change this chart like the days as range to make the chart user friendly. i.e., like 0-5, 10-20, 30-40, ...etc

similar to the below chart.

how can i do this.

please help me on this

[m_woolf · Accepted solution]

http://community.qlik.com/blogs/qlikviewdesignblog/2014/07/14/buckets

[krishna20]

Hi Rajendran,

Try by using Class() function.This may helps you...