Discussion board where members can get started with QlikView.
I have loaded two tables:
Tab1 and Tab2
[Field Value1]&'/'&[Field Value2] as CONCAT_TAB1;
Field Value1 Tab1,
Field Value2 Tab1,
Field Value3 Tab1,
Field Value4 Tab1
[Field Value1]&'/'&[Field Value2] as CONCAT_TAB2;
Field Value1 Tab2,
Field Value2 Tab2,
Field Value3 Tab2,
Field Value4 Tab2
This works great, however I now want to perform some calculations between the to CONCAT_TABx fields I have created.
I have successfully done the calculation in a chart expression but would like to do it in the script.
Essentially, I would like to know the syntax to select the fields from the two Tables.
I would like to do the following:
=IF(CONCAT_TAB1=CONCAT_TAB2,'Y','N') as New_Patient
=IF([Field Value1_Tab1]>1 and [Field Value3_Tab2]=0,'Y','N') as External_Provider
Can someone provide insight on how to achieve this within the script rather than a chart expression?
Join the tables so all the fields necessary for the calculation exist in one table. That's the only way.