Discussion Board for collaboration related to QlikView App Development.
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_DateFROM[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.
Based on the sample data the result should be like this:
I would like to request you to please provide the solution.
Thanks in advanced.
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) );
Thank for the reply.
Could you please provide any other alternate solution for this.
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.