Discussion Board for collaboration related to QlikView App Development.
I'm trying to load in a set of data regarding deliveries where you have an Order Number and each Order Number can have multiple Order Lines.
Each line has a Delivery Failed Flag to indicate whether the delivery was sucessful or not.
Is there a way in the script to mark the whole order as failed if any one of the lines fail?
[Order Num] [Line Num] [Failed?]
100 1 Yes
100 2 No
101 1 No
102 1 No
102 2 No
102 3 Yes
I know i need to create a new field to store the [Order Fail] record am and guessing it'll require a "Group" function but can't figure out how to do this.
Go to Solution.
Try with this approach.
if([Failed?]='Yes',1,0) as Failed
if(Sum(Failed)>=1,'Yes','No') as OrderFailed
Order Group By [Order Num];
Hope it helps
View solution in original post
Thanks very much Celambarasan!
Exactly what i needed!