Qlik

[Aravindvunnam]

Hai all,

My self Aravind,

I am a student and iam new to qlikview.

My requirement:

How to get the list of dates where order date and delivary date are done in a same day 

Order date.  Delivery date.  Status.

10-12-2021.  15-12-2021.      Completed

14-12-2021. 14-12-2021.  Completed 

11-12-2021.  13-12-2021.  Completed

08-12-2021. 08-12-2021  completed

Results we need is only  the list of order date  & delivery date are  done in same date

Result:-

Order date. Delivery date. Status 

14-12-2021  14-12-2021  completed

08-12-2021.  08-12-2021 completed

Please help me.

Thanks,

Aravind

[anat]

load * from file where  orderdate=deliverydate;

[vikasmahajan]

Hi Arvind,

While Loading Qlik Script you need to add below lines 

left join ( YourTableName)
LOAD Order_ID
Max(Order date) as Last_Sales_Order_Date
Resident  YourTableName
GROUP BY Order_ID;

You will get the last sales order date for all deliveries. To count deliveries per order you simply use count(Delivery_ID) or count(distinct Delivery_ID) as your chart expression.

Hope this help you.

Thanks

Vikas