Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Contributor III

Getting the sum of a comparison help

Hey guys,

I am trying to count the number of times a product is On Time and In Full. The way I am trying was nested aggregation, but that isn't allowed. Can any of you help me achieve my goal? The files are attached. Essentially I need to get the percentages on the Comp Pivot sheet in the excel file (on the right hand side). The attached Qlik file is currently trying to imitate the pivot tables on the excel file, to get the final table. Any suggestions? !