topic Script Expression Error in QlikView

Script Expression Error

Mon, 06 Sep 2010 10:51:06 GMT

Hey guys.

Im trying to find the on tme shipping % can anyone help me? this is my formula in script:

if(ShipDate-DueDate<=0,'On-Time','Late') as ShipmentStatus,

num(count(if(ShipDate-DueDate<=0,'On-Time','Late')'On-Time',/if(ShipDate-DueDate<=0,'On-Time','Late')'Late'),'#0%') as OnTime%

And this is the error:

Please help me

Script Expression Error

Mon, 06 Sep 2010 12:03:51 GMT

anyone?

Script Expression Error

Mon, 06 Sep 2010 12:05:35 GMT

Hi Blaze,

You could try use : count( {$<ShipmentStatus = {"On-Time"}>} value ) for the On-Time Count

Then another expression for Late : count( {$<ShipmentStatus = {"Late"}>} value )

Script Expression Error

Mon, 06 Sep 2010 12:24:34 GMT

Hey Xena.

Thanks for the reply. I tried :

=count( {$<ShipmentStatus = {"On-Time"}>})/count( {$<ShipmentStatus = {'Late'}>})

but it doesn't work.I need to take the total shipments made, whether they were late or not, and then divide by the number of late shipments to work out the On-time %. It also needs to be done in the script. Have u maybe got any other ideas? Thanks so much for your help i really appreciate it.

Script Expression Error

Mon, 06 Sep 2010 12:26:16 GMT

Hi Blaze,

Let us say you want to calculate the OnTime Shipment %. You have some fields InvNo, InvDt, ShipDate, DueDate, InvAmount, InvQty.

INVOICE_DETAILS:

LOAD CustomerCode,

InvNo,

InvDt,

ShipDate,

DueDate,

InvAmount,

InvQty,

If( ShipDate - DueDate <= 0,'On Time', 'Late') AS ShipStatus

FROM INVOICE_DETAILS.xls;

In the graphs (front end), you can write the expressions

= COUNT(DISTINCT If( ShipStatus = 'On Time', InvNo )) / COUNT( DISTINCT InvNo)

Let us say that you have 100 invoices out of which 60 was delievered on time and 40 was late delievery.

This expression will give you 60%.

Hope, it would helpful for you.

Thanks & Regards,

Raj Kishor

Script Expression Error

Mon, 06 Sep 2010 12:29:04 GMT

You can add this small bit into your script.

Script Expression Error

Mon, 06 Sep 2010 12:30:15 GMT

Hey Raj.

Thanks for the reply. I understand what you mean about the Invno, etc. I used this:

= COUNT(DISTINCT If( ShipmentStatus = 'On Time', PurchaseOrderNumber )) / COUNT( DISTINCT PurchaseOrderNumber)

Where PurchaseOrderNumber was the Order number and it still gives me -?

Any Ideas?

Script Expression Error

Mon, 06 Sep 2010 12:34:47 GMT

Hey Raj.

Your Formula worked. It was on my side. I wrote 'On Time' instead of 'On-Time'. My bad 🙂

Correct formula is this:

=num(COUNT(DISTINCT If( ShipmentStatus = 'On-Time', PurchaseOrderNumber ))/COUNT( DISTINCT PurchaseOrderNumber),'##,0%')

Thanks again for the help guys.