Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
bnelson111
Creator
Creator

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
Creator
Creator
Author

Got it.

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

Thank you.

View solution in original post

6 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Try this expression.

Sum(ConfirmedShippedQty * [Item Table.AREALABEL])

Or

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


Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Anonymous
Not applicable

try

* sum(temtableAREALABE)

could be because they are at different granular levels..

bnelson111
Creator
Creator
Author

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.

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Try this

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
bnelson111
Creator
Creator
Author

Got it.

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

Thank you.

bnelson111
Creator
Creator
Author

Thank you