I am looking for some assistance in a complicated matter that I have been dealing with manually but would like automate through qlikview scripting. I currently have a list of records that have part number and serial number and each part number and serial number may have multiple service types (OH or IN) with different due dates. I would like to write my script such that it will pull in two records (OH and IN) for each part number and Serial Number when the difference between “TTO/I/R” for OH and IN is greater than 600. If the difference between “ TTO/I/R” is less than 600 I would like to Force the “SVC_TYPE” to be OH at the DUE DATE of the lesser TTO/I/R Value of the two.
I have pasted an example of the data and how the solution may play out below. I am begging for your assistance on this major pain.