Deviation chart

[#1]

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])

[Gysbert_Wassenaar]

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.

[hareeshkumar_gv · Accepted solution]

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

[MarcoWedel]

Hi,

maybe something like this:

hope this helps

regards

Marco