Discussion board where members can get started with QlikView.
I am making a pivot table showing On Time In Full...
I have gotten to where I need to get the sum of In Full.
for my pivot table, this is my expression for In Full:
if((sum([Delivery quantity_OTIF]) - sum([Order Quantity_OTIF])) >= 0, 1, 0)
Now I am trying to get the sum of all of that data.
I am trying with this equation:
Sum(if((sum([Delivery quantity_OTIF]) - sum([Order Quantity_OTIF])) >= 0, 1, 0))
but I keep getting an error saying "Nested aggregation not allowed"
Any tips or help?
I'm just a little confused I guess because this equation DID work:
sum(if((num(date([Ac GI date_OTIF]))-num(Date([Pl GI date_OTIF]))) <= 0,1,0))
Thanks Vijay, you have been very helpful with this. I really appreciate you taking the time to look at this for me. It is now fixed on my end.