1 Reply Latest reply: Mar 22, 2013 7:42 AM by jaysuji17 RSS

    Creating a graph showing the difference in days between two dates

      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