Creating a graph showing the difference in days between two dates

[#1]

Hello,

I have been given the task to create an operational dashboard. My first task is creating a graph to show how long the users are booking the fees after the start date.

For example Start Date = 14/03/2012 & Booked Date = 18/03/2012, would fall into the 4-6 days field.

Offices listed |

                    |

                    |

                    |

                    |

                    |

                    |

                    |

                    |

                    |

                    |

                    |______________________________________________

                    1-3 days        4-6 days       7-9 days     10-12 days  .......

Could someone please tell me;

1. How I get QlikView to calculate the days between Start Date & Booked Date?

2. How I create the horizontal fields on the graph above (1-3 days, 4-6 days, etc) from the Start Date and Booked Date fields?

Thanks in advance for your help.

Kind regards,

John

[#2 · Accepted solution]

John

1. Select the chart type

2. Pull offices listed into dimensions and crate an additional calculated dimension

=Class([Booked Date]-[Sart date],30)

3. In the expressions tab create a simple expression

[Booked Date]-[Sart date]

4. Click OK.

you are good to go.

Sujay