topic Re: Straight table expression to multiply. in QlikView

Straight table expression to multiply.

bnelson111 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Straight table expression to multiply.

kaushiknsolanki — Thu, 17 Nov 2016 10:10:24 GMT

Hi,

Try this expression.

Sum(ConfirmedShippedQty * [Item Table.AREALABEL])

Sum(ConfirmedShippedQty) * Sum([Item Table.AREALABEL])

Regards,

Kaushik Solanki

Re: Straight table expression to multiply.

Anonymous — Thu, 17 Nov 2016 10:12:09 GMT

try

* sum(temtableAREALABE)

could be because they are at different granular levels..

Re: Straight table expression to multiply.

bnelson111 — Thu, 17 Nov 2016 11:31:56 GMT

The expression is perfect but once i remove a dimension the sum changes see below.

Correct 9,664,320

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.

Re: Straight table expression to multiply.

kaushiknsolanki — Thu, 17 Nov 2016 11:39:32 GMT

Hi,

Try this

Sum(Aggr(sum((ConfirmedShippedQty)) * Sum([Item Table.AREALABEL]),LinkITEMCODE,MonthSip....))

Regards,

Kaushik Solanki

Re: Straight table expression to multiply.

bnelson111 — Thu, 17 Nov 2016 11:45:01 GMT

Got it.

sum(aggr(sum((ConfirmedShippedQty)) * Sum([Item Table.AREALABEL]), [LinkITEMCODE]))

Thank you.

Re: Straight table expression to multiply.

bnelson111 — Thu, 17 Nov 2016 11:45:33 GMT

Thank you