topic Re: I want orders count that are not delivered in QlikView

I want orders count that are not delivered

Vinni2000 — Sat, 20 May 2023 17:37:44 GMT

have orders data like this

Order_no Item_no. Eroor Delivery_status

1011. 1. Null Delivered

1011. 2. Some_Error Undelivered

1012. 1. NULL Delivered

1013. 1. SOME_ERROR Delivered

SO HERE I WANT TO COUNT ORDERS WHERE ERROR IS NOT NULL AND UNDELIVERED , HERE I WANT THIS AT ORDER LEVEL NOT AT ITEM LEVEL . IF IN ORDER ONE ITEM NOT GOT AN ERROR MESSAGE AND DELIVERED WE CONSIDER WHOLE ORDER IS DELIVERED

Re: I want orders count that are not delivered

Vegar — Sat, 20 May 2023 18:23:33 GMT

Assuming that your null values are nulls (no value) and not the string 'NULL'.

Then you can try:

count({<Delivery_status={'Undelivered'}, Eroor={"*"}>}distinct Order_no)

Re: I want orders count that are not delivered

Vinni2000 — Sun, 21 May 2023 01:57:14 GMT

We want this at order level not at at item level

Re: I want orders count that are not delivered

Vegar — Sun, 21 May 2023 07:11:08 GMT

count distinct Order_no calculate the number of unique orders, not the number of items.

Did i misunderstand your criterias? What is the expected output of the first two rows in your samplr, order 1011.?

Re: I want orders count that are not delivered

Vinni2000 — Sun, 21 May 2023 07:43:11 GMT

There you can see item number right for 1011 order we have two items 1, 2 and i has error and doesn't have error so count order numbers where we got some error so we should not count the order if one item from order not got error and delivered .

Re: I want orders count that are not delivered

Vegar — Sun, 21 May 2023 10:25:14 GMT

I see, thats how I understood it from the beginning. Please explain what's wrong with my initial suggested solution. Did you try it? It should, as I see it, return the output that you are asking for.