topic Re: On Time In Full Percentage Wise in QlikView

On Time In Full Percentage Wise

Thu, 11 Oct 2012 09:29:51 GMT

Hello Everyone,

I need to devlop a chart showing otif percentage values

below is my sample data

i need to delevop charts with like below one

Can some one help me out

Thu, 11 Oct 2012 10:04:05 GMT

He Vikram,

You could try joining the tables.

And then create flags for ontime,onfull and OnTime OnFull.

For example:

If(Delivery Date=Actual Delivery Date and Quantity<>Quantity delivered,1,0) as Flag_OnTime

If(Delivery Date<>Actual Delivery Date and Quantity=Quantity delivered,1,0) as Flag_OnFull

If(Delivery Date=Actual Delivery Date and Quantity=Quantity delivered,1,0) as Flag_OnTimeOnFull

Hope this helps.

Gr.

Frank

swuehl — Thu, 11 Oct 2012 10:21:08 GMT

Creating some flags in the script is probably a good idea.

If you want to do it in the front end, you can start with creating a straight table chart with no dimension and three expressions:

=count(if([Delivery date]=[Actual Delivery Date],[PO ID])) / count([PO ID])

=count(if(Quantity=[Quantity delivered] ,[PO ID])) / count([PO ID])

=count(if([Delivery date]=[Actual Delivery Date] and Quantity=[Quantity delivered],[PO ID])) / count([PO ID])

Set an appropriate number format for the percentages in number tab and check 'Horizontal' option in presentation tab.

Regards,

Stefan