Discussion Board for collaboration on QlikView Scripting.
I have a requirement in which i have Order Number,Order Date,Delivery Date and Department
Suppose i Received 100 Orders on the Date 25-03-2014 and have different delivery dates 27-03-2014,28-03-2014...........31-03-2014
Each day i may deliver different number of orders ,like on 27-03-14 i delivered 30 orders,next day i delivered 10 orders and so on ....
on 31-03-2014 I may deliver 5 orders. So my 100 orders were Completed and i delivered all and Achieved 100%. But i want to know
How Many Days it took me to achieve 95% i.e on which day i completed or the number of Days took me to deliver 95 orders.
So how can i do this .
I have attached the Sample Data and Applications.
Thanks in Advance.
Nikitha Jain M.B
You probably need a Pareto Chart, see here: http://community.qlik.com/blogs/qlikviewdesignblog/2013/12/09/pareto-analysis for details.
hi thanks for ur reply,
but i need the NUMBER OF DAYS TAKEN TO ACHIEVE 95% OF ORDERS.
See attached qvw.