Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Conditional sum on cell values

Good Morning to all,

I have a pivot table like this

LoadingDischargePodOriginaleQ.tàQuan.+Q.Tot????
ABIDJANANVERSAANVERSA3073721
ABU DHABIABIDJANABIDJAN011
ALEXANDRIAABIDJANABIDJAN02020

Now I need to have an additional column ('????') where the result must be the Sum of all the where "Discharge" is equal to the corrisponding "Loading" Port.

Referring to the example, I need, for the first row, an additional column where, I have the sum of the Abidjan of the second row.

In this simply case: 21

Is it possible?

Could anyone help me?

Thanks in advance

0 Replies