Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Expression for Counting Certain Days

Dear All,

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

3 Replies
thornofcrowns
Valued Contributor II

Re: Expression for Counting Certain Days

You probably need a Pareto Chart, see here: http://community.qlik.com/blogs/qlikviewdesignblog/2013/12/09/pareto-analysis for details.

Not applicable

Re: Expression for Counting Certain Days

hi thanks for ur reply,

but i need the NUMBER OF DAYS TAKEN TO ACHIEVE 95% OF ORDERS.

Re: Expression for Counting Certain Days

See attached qvw.


talk is cheap, supply exceeds demand
Community Browser