Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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