topic Comparing not associated columns in QlikView

Comparing not associated columns

MWiciok — Mon, 02 Dec 2013 08:51:12 GMT

Hi all,

I've got a question concerning comparing expressions of not associated columns. My set up looks like this:

Table1:

Column1	Column2
A	1
B	2
C	3

Table2:

Column3	Column4
A	1
A	1
B	2
C	1
C	2
D	3
E	4

Now I want to calculate, how often the sum of Column4 grouped by Column3 equals the value in Column2. I got something like

=count(Column1 = aggr(Column3,Column1))

this gets me the number of sets of Column1 which are also in Column3. But I want to get a step further and expand this expression by comparing the sums of Column2 and Column4.

Do you know what I mean? Can you please help me?

Oh, I want these columns not to be associated....

Thanks in advance

Re: Comparing not associated columns

Anonymous — Mon, 02 Dec 2013 15:38:46 GMT

Hi Matthias,

See attached if this is what you want.

Regards,

Michael

Re: Re: Comparing not associated columns

MWiciok — Tue, 03 Dec 2013 08:18:10 GMT

Well, this is the right direction. But I want to count the Yes-Rows.

I solved this matter by creating a new table and there store the values. See attached file for this.