topic Re: sumproduct function in QlikView

sumproduct function

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

Hi everyone

I have These tow tables:

item number	year	Customer	qty
100	1395	A	2
200	1395	A	2
300	1395	B	3
400	1395	B	5
100	1396	A	5
200	1396	A	6
300	1396	B	7
400	1396	B	5

item number	per unit
100	90
200	40
300	30
500	20
400	50

I would like to now the total quantity based on per unit for each customer,actually, something like sumproduct function in excel.

The result should be:

Customer	Qty*Unit
A	950
B	800

Is that a way to do that in qlikview straight table?

Re: sumproduct function

tresB — Mon, 13 Nov 2017 11:10:25 GMT

Have you tried like:

Dimension: Customer

Expression: Sum(Qty*Unit)

Re: sumproduct function

prma7799 — Mon, 13 Nov 2017 11:12:43 GMT

like this

Re: sumproduct function

shanky1907 — Mon, 13 Nov 2017 11:13:28 GMT

Hello Ali,

Take a chart as an object then select Straight Table as chart type.Take Customer as Dimension and in the Expression keep Qty*Unit and you can give it a name as desired.

Re: sumproduct function

Anonymous — Mon, 13 Nov 2017 11:27:05 GMT

Hi Shashank Vyas

Thanks it was helpful.