I can see some yellow rows and Blue rows in buy artical available data. Is there a condition you used to make it yellow and blue. or you just colored it in your excel sheet. Qlikview wont recognize the colour from data source as far as my knowledge. if there is any condition to select those coloured boxes, then you can just let us know.
Sorry for the confusion. I only colored the data in Excel to show how I want to calculate the data.
Let me try and explain the data better;
Top-level assembly ABxx1021A4 are built up of two sub-assemblies, ABxx0100A7 and ABxx0100A7 (same assembly but disregard this)
Each sub-assembly are built up with different material (colored yellow and blue in the spreadsheet just for illustration).
I want to calculate an Available Date for each sub-assembly and top-assembly based on the buy articles Available Date and the Mfg. LT of the assembly.
---
Expression for Subassembly line 9 should be something like;
=max(Buy Article Available Date) + Process LT (but only max of data in line 4-8)
Expression for Subassembly line 2 should be something like;
=max(Buy Article Available Date) + Process LT (but only max of data in line 10-15)
How do I take max of a sub-set of data in an expression?
---
Expression for Top-assembly;
=max of calculated Available Date for Subassemblies + Mfg. LT for top-assembly
How do I make an expression on a calculated data?
Alternatively if I can use;
=max(Buy Article Available Date) + Process LT of both sub-assembly and top-assembly
---
Best Regards,
Jonas
So, what I'm trying to do is take the maximum Available Date for a level and a the manufacturing LT. Something like;
=max(Buy Article Available Date) + Process LT
The problem is that I only want to take max of a subset of data. For example, line 9 in the spreadsheet should only be max of line 10-15 as these are level 2 and belong to the above level 1.
