Discussion board where members can get started with QlikView.
I have two .qvw : GetData.qvw (load data from SQL DB creating qvd) and ShowData.qvw (load data from qvd and prepare data to be presented).
In the SQL DB there are two tables that I import creating two distinct qvd(s): table1.qvd and table2.qvd.
In the ShowData.qvw I have to load the two qvd(s)
In the ShowData.qvw I would have a calculated field C = A-B, for all the rows in Table1 (left join).
I did as follow:
And it works, but I'm not sure that this is the best way to do it as it requires loading the data a second time in order to do the calculation.
Can someone help?
Here is an alternative approach:
A - applymap('MAP',Key) as C
Thanks for the suggestion, the problem is that tables have more than two fields. If I understood well how the map works, I can'use it as Tables1 and Tables2 have more fields.
Many Thanks, Martina