sumproduct function

[Anonymous]

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?

[tresesco · Accepted solution]

Have you tried like:

Dimension: Customer

Expression: Sum(Qty*Unit)

[prma7799]

like this

[shanky1907]

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.

[Anonymous]

Hi Shashank Vyas

Thanks it was helpful.