topic Re: Count of Missing orders in QlikView

Count of Missing orders

Vinni2000 — Mon, 15 May 2023 16:54:29 GMT

I need to show count of un delivered orders in KPI , so here confusion is in one order we may have multiple items , in data we have data for all the items with different delivery number so here I how to show count of un delivered orders "not at item level" so here in order we have multiple items and delivered only one item then also we need to consider that as delivered

Re: Count of Missing orders

Kushal_Chawda — Mon, 15 May 2023 19:59:30 GMT

@Vinni2000 How to identify that Order is delivered? What is condition?

Re: Count of Missing orders

Vinni2000 — Tue, 16 May 2023 03:33:10 GMT

Here we have orders table , item table and delivery table . In orders table we have information like order number and order date in item table we have item details of particular order and in delivery table we have delivery information of all the items . So here we have to join all the table by using order number and left outer join. So here if we deliver one item from the order we need to consider that order is delivered . Means we are building dashboard at order level not at item level