Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Trying to get the sum of a comparison.

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?

0 Replies