topic Re: Deviation chart in QlikView

Deviation chart

Fri, 26 Feb 2016 14:27:13 GMT

Hello,

Is there a visualization that allows me to display Deviation.

I am trying to plot the difference between "Promised shipment date" and "Actual shipment date" so I would like to show "Zero" in the center and -/+ on either side so I can easily see if more shipments leave on time or not.

Any help would be great.

Below is my formula for finding the value for each invoice.Which gives me a number of days difference between the promised date and shipment date.

([Sales Order Line Archive.Promised Delivery Date]) - [Invoice Header.Shipment Date])

Re: Deviation chart

Gysbert_Wassenaar — Fri, 26 Feb 2016 17:52:32 GMT

You could use a bar chart. Or you can try using a boxplot. Or perhaps a gauge or a text box if you're only interested in an average.

Re: Deviation chart

hareeshkumar_gv — Fri, 26 Feb 2016 18:02:38 GMT

Hi Derek,

We can do in bar chart like positive bar and negative bar, We can set the limit in bar chart, Please add your expression like below

if(([Sales Order Line Archive.Promised Delivery Date]) - [Invoice Header.Shipment Date])<0,

dual('your layout definition',(([Sales Order Line Archive.Promised Delivery Date]) - [Invoice Header.Shipment Date])),

(([Sales Order Line Archive.Promised Delivery Date]) - [Invoice Header.Shipment Date]))

Qlikview internally stores for date fields in numeric and string format, the numeric number of 12/31/1899(MM/DD/YYYY) is 1, and 01/01/1900(MM/DD/YYYY) is 2 and ..... Like this qlikview stores the Dates, so we can do Arithematic operations(+ or -) on dates

Re: Deviation chart

MarcoWedel — Sat, 27 Feb 2016 03:08:52 GMT

Hi,

maybe something like this:

hope this helps

regards

Marco