Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
bnelson111
Contributor

Straight table expression to multiply.

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.

brett1.png

Working when single item selected.

Untitled.png

Hope this makes sense. Thanks Brett

1 Solution

Accepted Solutions
bnelson111
Contributor

Re: Straight table expression to multiply.

Got it.

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

Thank you.

6 Replies

Re: Straight table expression to multiply.

Hi,

Try this expression.

Sum(ConfirmedShippedQty * [Item Table.AREALABEL])

Or

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


Regards,

Kaushik Solanki

qlikdeez
Valued Contributor

Re: Straight table expression to multiply.

try

* sum(temtableAREALABE)

could be because they are at different granular levels..

bnelson111
Contributor

Re: Straight table expression to multiply.

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

Correct 9,664,320

brett1.png

Remove Linkitemcode dimension

Untitled.png

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.

Hi,

Try this

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

Regards,

Kaushik Solanki

bnelson111
Contributor

Re: Straight table expression to multiply.

Got it.

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

Thank you.

bnelson111
Contributor

Re: Straight table expression to multiply.

Thank you