topic Re: Delivery Gauge Chart in QlikView

Delivery Gauge Chart

Anonymous — Wed, 05 Feb 2014 12:34:29 GMT

I have a good working pie chart that shows delivery performance (by using proceeding load). it splits late, early and ontime in to percentages and works very nicely. i wanted to then have a second chart as a Gauge to show unnacceptable lateness - ie over 10% the needle goes into red.

I cannot for the life of me work out what i have to put in the expression to get this, i tried:

Sum(DelPerformance = 'Late') / Sum(DelPerformance) ... but this obviously didnt work, can any one help?

this is the data that is in the script that the pie chart which works fine is looking at:

LOAD *,

If(DelPerf =0, 'OnTime',

If(DelPerf >=1, 'Early',

If(DelPerf <=-1, 'Late'))) AS DelPerformance;

LOAD Invoice,

LineShipDate,

CustRequestDate,

(CustRequestDate-LineShipDate) AS DelPerf;

Re: Delivery Gauge Chart

jonathandienst — Wed, 05 Feb 2014 12:40:37 GMT

You need something like this:

Count({<DelPerformance = {'Late'}>} DISTINCT Invoice) / Count(DISTINCT Invoice)

HTH

Jonathan

Re: Delivery Gauge Chart

Anonymous — Wed, 05 Feb 2014 13:30:20 GMT

no that didnt work,

am i correct in thinking there shouldnt be any dimensions?

attached are screen shots of the chart pres and expression

Re: Delivery Gauge Chart

kiranmanoharrode — Wed, 05 Feb 2014 13:41:00 GMT

Dear James,

Try Below expression

=Count(Distinct {<DelPerformance = {"Late"},DelPerf={"<=0.1"}>} Invoice)

Regards

Kiran

Re: Delivery Gauge Chart

kiranmanoharrode — Wed, 05 Feb 2014 13:42:33 GMT

Please attach Sample application for better understanding..

Re: Delivery Gauge Chart

Anonymous — Wed, 05 Feb 2014 13:46:57 GMT

whats best way to do that?

Re: Delivery Gauge Chart

kiranmanoharrode — Wed, 05 Feb 2014 13:50:34 GMT

just take dummy data and make sample application and describe your desired result in that application

Re: Delivery Gauge Chart

Anonymous — Wed, 05 Feb 2014 14:23:30 GMT

this is the script where the info pulls from (invoice is what joins it to the other tables)

LOAD *,

If(DelPerf =0, 'OnTime',

If(DelPerf >=1, 'Early',

If(DelPerf <=-1, 'Late'))) AS DelPerformance;

LOAD Invoice,

LineShipDate,

CustRequestDate,

(CustRequestDate-LineShipDate) AS DelPerf;

SQL SELECT Invoice,

LineShipDate,

CustRequestDate

FROM SysproCompanyA.dbo.SorDeliveryPerf;

i want to show via a gauge a pointer that shows where we are on lateness ie whether its at an acceptable level at under 10% (green) or an unnacceptable level over 10% (red).

Might be best to start the gauge set up from scratch just incase ive done something wrong in the presentation?

Re: Delivery Gauge Chart

Anonymous — Wed, 05 Feb 2014 15:04:21 GMT

This one actually worked in the end - i redid the gauge from scratch and it worked so i mustve selected something wrong in the set up.. thanks for everyones help