Discussion Board for collaboration on QlikView Scripting.
I've got in my module,
the following tables:
I need to calculate for each item sum(Qty) where SaleDate<= Date.
I know set analysis back and forward but somehow i can't manage to do that.
Can someone know how to solve this issue?
Thnx a lot
Solved! Go to Solution.
I dont know if im missing somethign here, but you dont need set analysis. You just need an if statement in the expr =sum(if(SalesDate<=Date,Qty)). Please check the attached.
Yes both solutions will work, but if statements produce slower results than using set analysis. It is optimal to use set analysis over if statements whenever possible