Set analysis Concept

vipingarg23 — Thu, 18 Jan 2018 17:25:53 GMT

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?

topic Set analysis Concept in QlikView