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?