I have a problem that I can't figure out. I am trying to get the sum of when a product is on time and in full. I have gotten the On Time (OT) portion and got help to find In Full (IF), here is the link to the files if you don't mind taking a look for me. The excel sheet has the output on the Comp Pivot sheet. Essentially, I just need to get the percentages in the box to the right of that sheet from the raw data in Qlik. Thanks!
