Hi all, i am new to Qlikview.
I have some issue as below and hope anyone can provide suggestions to me
Table1:
Class,
Owner ,
Qty,
Table2:
Class,
Owner
- I create two new fields, Column X and Column Y at table 1 when loading data from Access files
- Then I update new fields value by using ApplyMap function
- Now using field ‘class’ at Table 1 as Criteria (if class="c" or class="e") to update Column X again (conditions: class and Owner between table 1 and table 2 is match before it apply update mechanism)
How can i achieve of it. Many thanks
Mic