topic Comparing same column from different tables... in QlikView

Comparing same column from different tables...

charlesdmeyer — Wed, 25 Nov 2020 16:16:04 GMT

I have two sets of student testing data. One from the Fall, one from the Winter. They have the exact same column names. I want to compare a student's score on Fall test to Winter test.

Is there a way to create an equation to look at Goal 1 for Fall and compare to Goal 1 for Winter.

I know that is vague but I hope someone knows.

Re: Comparing same column from different tables...

Anil_Babu_Samineni — Thu, 15 Feb 2018 14:04:06 GMT

The way, I can think this way?

Load Field1, Field2, Field3, 'T1' as Flag From T1;

Load Field1, Field2, Field3, 'T2' as Flag From T2;

Then, think about this way?

If(Sum({<Flag={T1}>} Field3)=Sum({<Flag={T2}>} Field3), 1, 0) as Final_Flag