topic Re. :Re: Re. :Re: Sum when 2 column are equal in QlikView

Sum when 2 column are equal

Tue, 05 Oct 2010 07:12:18 GMT

When i select 'AA' in Fam1. I am trying to sum the column 'CA' for one customer when value of 'Fam1' = 'Fam2' like the Result Table.

Try with aggr but don't seem to work. Is it possible ?

Thanks

Sum when 2 column are equal

Tue, 05 Oct 2010 08:23:14 GMT

Hi Marlot,

Here you are a possible solution.

Regards.

Re. :Re: Sum when 2 column are equal

Tue, 05 Oct 2010 10:46:16 GMT

Thanks a lot for your solution.

Is it possible to add the total CA for the Customer 003. (New Exemple) With Selected Fam1=AA

Re. :Re: Sum when 2 column are equal

llauses243 — Tue, 05 Oct 2010 12:57:30 GMT

Hi,

This is my offer ...

Good luck, Luis

Re. :Re: Re. :Re: Sum when 2 column are equal

Tue, 05 Oct 2010 13:38:59 GMT


llauses wrote:
Hi,
This is my offer ...
Good luck, Luis<div></div>

Thanks ... but in my real case i only want to select fam1. I don't know if it is possible

Re. :Re: Sum when 2 column are equal

Tue, 05 Oct 2010 16:28:30 GMT

Hi marlot,

That isn't possible because you want fam1 field as dimension and you are selecting 'AA' in that field, so you would never get the null value for the Customer 003.

Regards.

Re. :Re: Re. :Re: Sum when 2 column are equal

Tue, 05 Oct 2010 19:50:12 GMT

Well, Finally this a solution. It seems to work. I create a new field and compare it with set analysis.

Thanks for all your suggestions