SUM with IF

[irmantas]

Hi all,

I have two tables without a shared key.

ProductId	SalesQty
X	5
Y	2
Z	6

InventId	StockQty
X	100
Y	50

In Pivot I want show sum of SalesQTY and sum of StackQTY. Were ProducId = InventId.

sum({ <ProductId=InventId>} StockQty) is not working.

[shiveshsingh]

Try this

=SUM({<ProductId = {$(=InventID)}>}StockQty)

[prma7799]

Please share some sample data.

[irmantas]

Not working, sums all StockQTY of all InventId

[irmantas]

See up I was shared.

[shiveshsingh]

Let me check, i thought you are having only one inventID

[tamilarasu]

Could you draw expected output format for below example?

[PrashantSangle]

Hi,

try with aggr() and distinct

like aggr(Distinct sum(if(InventId=ProductId,(StockQTY))),dimesionfield)

[irmantas]

What does it mean "dimesionfield"?

[prma7799]

dimesionfield (simply your Dimension ) 

Check this

aggr(Distinct sum(if(InventId=ProductId,(StockQTY))),ProductId)

[prma7799]

Check this

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/aggr.htm