Time Diagramm

[rolandg1881]

Hi everybody!

Today a complicated question (for me).

Details in the paint 😉 image attached.

Our quality department wants to analyse their complaints.

i take the data from our erp system to qlikview but i have a problem.

There is the date where the complaint is registerd in the erp system, this date is my link to the mastercalendar.

Now there are some status of the complaint. 

1. we record it

2. it goes to the quarantine stock

3. it goes in production

4. it goes in the delivery stock

5. and it goes back to the customer

i did not check how i can i create a timeline (like the diagram in the attachment) because i have only a link to the start date of the complaint to the mastercalender?

Does anybody has in idea how i can solve this "problem"?

Thank you for answers!

[derekjones]

Hi

Use baroffset in the chart, simple example attached

[rolandg1881]

Hi Derekjones!

Thank you for the answer, looks good. But i have a problem.

I think its a date format problem because i got no result with my values and in my timeline are dates like 

05.11.1899. I sent my screenshot in the attachment.

i explain how i got the data:

with sql i take the date in the table, i have to convert it because it comes in a Date/Time Format from the ERP witch is not usable.

CONVERT(CHAR(10), RMA.yreklam, 104) AS RMA_ReklaDatum,

then i load the RMA_ReklaDatum in the Qlikview table.

My last attempt was to load it like this:

Date(RMA_ReklaDatum) as RMA_ReklaDatum

no result!

Do you have any ideas whats wrong?

Thank you!

[derekjones]

Hi Roland

Sorry I can't open your screenshot, however I think I know the issue, my date configuration is UK based i.e. DD/MM/YYYY. Also, you use dots instead of slashes for your date dividers. I've adjust the script, take another look using this revised app

[rolandg1881]

Hi!

Thank you very much. It was my "problem"! 😉

I did not check whats the bar offset so i forgot to change the values. Now it works!

i have only one more question. Whats the best way to to see also the duration in the diagramm?

It's again only a subtraction of the dates but its not Date Format it's a number of days.

Can i integrate this number of days IN the bar?

Thank you!

[derekjones]

Hi, sure, one way is to change the number format on the expressions to an integer rather than date, however this would change the format of the axis, so you need to trick it to thinking its a date by adding another expression before the bars with date format. I'm sure there might be a neater way in doing this using dual function but this is nice and simple. 

Example update attached

[rolandg1881]

Thats perfect!

Thank you very much for your help!