Discussion board where members can get started with QlikView.
Everyone this is a strange one that should be simple however i cant get the desired result. See below i have used the expression as the labels on the straight table and table box to try and explain.
Okay basically the sum of the confirmedshippedqty is working but when i try to multiply by the itemtableAREALABEL the expression is null. It works when single items are selected.
Working when single item selected.
Hope this makes sense. Thanks Brett
Go to Solution.
sum(aggr(sum((ConfirmedShippedQty)) * Sum([Item Table.AREALABEL]), [LinkITEMCODE]))
Try this expression.
Sum(ConfirmedShippedQty * [Item Table.AREALABEL])
Sum(ConfirmedShippedQty) * Sum([Item Table.AREALABEL])
could be because they are at different granular levels..
The expression is perfect but once i remove a dimension the sum changes see below.
Remove Linkitemcode dimension
calculation is sum((ConfirmedShippedQty)) * Sum([Item Table.AREALABEL])
dont want to use a pivot table, require the second table but correct sum.
Sum(Aggr(sum((ConfirmedShippedQty)) * Sum([Item Table.AREALABEL]),LinkITEMCODE,MonthSip....))