Discussion Board for collaboration related to QlikView App Development.
Hello! I would appreciate if someone can help me on this...
I have an expression in pivot table that I would like to put it in script :
= rangesum(before(total sum(if(SalesQty >0, SalesQty )),0,NoOfColumns(TOTAL)))
my table is showm below :
Rangesum: NoConcatenate loadProduct,
f(Product = previous(Product]), rangesum(SalesQty, peek(Sales_Accu)),SalesQty) as Sales_Accu,
But the output doesn't come out right. Below is my expected out put in yellow shade ::
Pls. advise...Btw, my expression in pivot table works perfectly.
Thank you in advance.
This should work
if(Product = previous(Product]),
If(Company= previous(Company), rangesum(SalesQty, peek(Sales_Accu)),SalesQty),SalesQty) as Sales_Accu,
View solution in original post
Try using Order by
Company, WeekDate ASC;
I tried but it only work on Com A ... 1st week 03/06 Com B and C has different value ...not sure where they come from.
It still doesn't work but I added if(Location = previous(location]) and it worked now. Thank you so much.