topic Cumplimiento de Fechas in QlikView

Cumplimiento de Fechas

Tue, 27 Sep 2011 11:40:21 GMT

Buen dia,

Apreciaria la ayuda para el siguiente caso:

Tengo una tabla de Ventas con dos Fechas:

1.- Fecha Orden

2.- Fecha Entrega

Lo que deseo hacer es que me muestre la Cantidad y Porcentaje de Ordenes que fueron entregadas en 5 dias o menos posteriores a la "Fecha Orden"

Gracias anticipadas por la ayuda que puedan Bindarme.

Would appreciate support for the following case: I have a table available with two dates: 1 .- Date Order 2 .- Delivery Date I want to do is show me the number and percentage of orders that were delivered in 5 days or less after the "Order Date" Thanks in advance for the help

Cumplimiento de Fechas

Tue, 27 Sep 2011 11:51:02 GMT

Good Morning to all,

I would appreciate support for the following case:

I have a table available with two dates:

1 .- Date Order

2 .- Delivery Date

Wath I want to do is show the number and percentage of orders that were delivered in 5 days or less after the "Order Date"

Thanks in advance for the help

Cumplimiento de Fechas

mazacini — Tue, 27 Sep 2011 14:50:58 GMT

Create a new field in load to calculate the time taken to deliver

DeliveryDate - OrderDate as TimeTaken

Then in a Straight Table

Expression 1 - Total Orders, something like COUNT(ORDERS)

Expression 2 - SET Analysis, Total Orders where Time Taken <6, something like COUNT({<TImeTaken<6}>}ORDERS).

Expression 3 - Expression 2 / Expression 3 - in number tab, set to integer, percentage.

You may need to modify above depending on data types for date and value fields.

Joe

Cumplimiento de Fechas

Tue, 27 Sep 2011 21:44:49 GMT

Hi Maczacini,

2.- Expression 1 - Total Orders

COUNT(T$ORNO)

3.- Expression 2 - Days

COUNT({<TImetaken<6}>}T$ORNO)

4.- Expression 3 - Expression 2 / Expression 1

[Days]/[Total Orders]

But didn´t work, when I substract the dates, It show me wronng values

Thanks for your quick response, I just want to show how many orders was delivery in the firts 5 days after it Order date and How is the % for each month.

Let me explain what I did, (DIMENSION = MONTHS)

1.- Create a new field in load to calculate the time taken to deliver

LOAD *inline [T$DDAT$O-T$ODAT as Timetaken];

Cumplimiento de Fechas

mazacini — Tue, 27 Sep 2011 23:06:02 GMT

What about 'interval'?

Something like:

interval((T$DDAT$0-T$ODAT),'dd') as Timetaken