Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MWiciok
Creator
Creator

Comparing not associated columns

Hi all,

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

Table1:

Column1Column2
A1
B2
C3

Table2:

Column3Column4
A1
A1
B2
C1
C2
D3
E4

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

1 Solution

Accepted Solutions
MWiciok
Creator
Creator
Author

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.

View solution in original post

2 Replies
Anonymous
Not applicable

Hi Matthias,

See attached if this is what you want.

Regards,

Michael

MWiciok
Creator
Creator
Author

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.