topic Qlik in App Development

Qlik

Aravindvunnam — Tue, 18 Jan 2022 10:10:52 GMT

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

Re: Qlik

anat — Tue, 18 Jan 2022 10:19:08 GMT

load * from file where orderdate=deliverydate;

Re: Qlik

vikasmahajan — Thu, 20 Jan 2022 10:08:11 GMT

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