Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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? !