Set analysis Concept

[vipingarg23]

Hi Team,

I need to convert below code into QlikView:

Select

  *

From

  Tab1,

  Tab2,

  (Select A, B, C Class From tab3  Where Date1 <= 'test1(According to user selection)' and Date2 > 'test1') Tab1_new,

  (Select A, B, C Class_New From tab3  Where Date1 <= 'test2(According to user selection)' and Date2 > 'test2') Tab2_new

Where

.....(Some Join Condition) AND Tab1_new.Class<>Tab2_new.Class_New

.Here: Value of test1 and test2 will based on users selection.

Now I am doing below to solve this:

I have joined these table in script and I am using set analysis in straight table to apply the condition. But I am not able to apply below condition:

Tab1_new.Class<>Tab2_new.Class_New

Can anyone help me, how can I get value for Class and Calss_New at front end to apply this filter?