Discussion Board for collaboration on QlikView Scripting.
some set analysis help please! i'm trying to Sum a field whilst getting the Max value from another (if that makes sense)
i only want to Sum the Actual for the Max(Quarter) when the Actual > 0
so in the above example i'd be summing the Actual for Quarter 2 = 10,500
thanks in advance
Solved! Go to Solution.
afraid not. the first expression returns nothing, the second zero
the second expression looks most likely (not quite sure i fully understand the dollar expansion though - my set analysis is pretty basic!)