Delivery Performance for own company

[Anonymous]

Hi, I notice on the forums that there are plenty of Delivery tables for supplier performance, but i am trying to evaluate my own companies delivery performance to our customers... does anyone know of any good ones i can use as a template?  presumably i would have to use IF statements like greater than 2 days = late etc?

[#2]

Did you glanced through demo apps on qlik.com?

[Anonymous]

No I havent, just need the correct wording for saying something like IF<than 1 day = late etc

[Anonymous]

Still Struggling with this, tried looking at some similar posts and have got to a point where i am now stuck again.  I added the DelPerf line which has given me a numeric value, but now trying to change that numeric val into a word such as "Late", "Ontime" and "Early"?  this is where i have got to but doesnt seem to work....Help!

Deliveries:

LOAD SalesOrder,

    PlannedDeliverDate,

    ActualDeliveryDate,

    (PlannedDeliverDate-ActualDeliveryDate)AS DelPerf,

    If(DelPerf>=0, 'OnTime',

    If(DelPerf =>1, 'Late',

    If(DelPerf <=1, 'Early'))) AS DelPerf2;

[marcus_malinow]

Hi James,

you're running into problems because by the time you do the condition on DelPerf it isn't available.

You can solve this by using a preceding load like so:

Deliveries:

LOAD *,

    If(DelPerf>=0, 'OnTime',

    If(DelPerf =>1, 'Late',

    If(DelPerf <=1, 'Early'))) AS DelPerf2;

LOAD SalesOrder,

    PlannedDeliverDate,

    ActualDeliveryDate,

    (PlannedDeliverDate-ActualDeliveryDate)AS DelPerf;

Marcus

[#6]

You can't use the new derived field in the same LOAD statement, You need to do in preceding load like Marcus suggested,

[jpapador]

You could Try:

If((Num(Today()) - Num(DelPerfDate)) > 2, 'Late', 'On-Time') as DeliveryStatus

[Anonymous]

Error in expression:

')' expected

Deliveries:

LOAD *,

    If(DelPerf>=0, 'OnTime',

    If(DelPerf =>1, 'Late',

    If(DelPerf <=1, 'Early'))) AS DelPerf2

[marcus_malinow]

Hi James,

I can't see a missing close bracket there, perhaps it's the DelPerf expression as there's no space between the close bracket and 'AS'.

QlikView error messages can sometimes be slightly misleading...

Marcus

[marcus_malinow]

Also, make sure there's a semicolon after DelPerf2 and before the next LOAD