topic Re: Need to display the order id and quantity based on script logic. in QlikView

Need to display the order id and quantity based on script logic.

iahmadmca — Sat, 16 Nov 2024 02:46:41 GMT

Hi Team,

I have one requirement which i need to get the result based on script level. Provided the below requirement details.

I am using the below script logic to get it done but it is not coming.

Order:
LOAD [Order id],
Quantity,
Order_Date
FROM
[C:\Users\Irshad .Ansari\Desktop\Daily work activity.xlsx]
(ooxml, embedded labels, table is Sheet2)

where [Order id]<>1 or Order_Date<>null() and Order_Date<> Previous(Order_Date);

Note: one order_id should be one quantity and quantity Order date should be first inter value it should not be change.

sample data.

Order id	Quantity	Order_Date
1	2	------
1	3	------
1	4	1-jun-2019
1	6	1-Jun-2019
2	7	1-Aug-2019
3	9	------

Based on the sample data the result should be like this:

Order id	Quantity	Order_Date
1	4	1-jun-2019
4	7	1-Aug-2019
3	9	--------

I would like to request you to please provide the solution.

Thanks in advanced.

Regards,

Irshad Ahmad

Re: Need to display the order id and quantity based on script logic.

Claudiu_Anghelescu — Mon, 12 Aug 2019 08:34:44 GMT

where ( [Order id]<>1 or Order_Date<>null() ) and Order_Date<> Previous(Order_Date);

where [Order id]<>1 or ( Order_Date<>null() and Order_Date<> Previous(Order_Date) );

Re: Need to display the order id and quantity based on script logic.

iahmadmca — Tue, 13 Aug 2019 04:43:47 GMT

Thank for the reply.

Could you please provide any other alternate solution for this.

Re: Need to display the order id and quantity based on script logic.

iahmadmca — Tue, 13 Aug 2019 15:39:33 GMT

This logic is working fine, but when I am changing the quantity for existing Id its getting reflect on that. The quantity should not be changed. It should be first entered in quantity.