topic Re: Time Diagramm in QlikView

Time Diagramm

rolandg1881 — Thu, 25 Feb 2021 09:31:01 GMT

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!

Re: Time Diagramm

derekjones — Thu, 25 Feb 2021 15:25:37 GMT

Use baroffset in the chart, simple example attached

Re: Time Diagramm

rolandg1881 — Fri, 26 Feb 2021 09:07:07 GMT

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!

Re: Time Diagramm

derekjones — Fri, 26 Feb 2021 10:06:50 GMT

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

Re: Time Diagramm

rolandg1881 — Sat, 27 Feb 2021 12:14:50 GMT

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!

Re: Time Diagramm

derekjones — Mon, 01 Mar 2021 09:16:26 GMT

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

Re: Time Diagramm

rolandg1881 — Mon, 01 Mar 2021 22:27:00 GMT

Thats perfect!

Thank you very much for your help!