I was stuck with a problem and wanted help with it.
I have loaded a excel files into Qlikview and joined 3 tables to form one. Now i want to modify a field in one table based on a condition that involves a field from another table.
My script looks like below
Load custID, Country from ....
Load custID, Status from .......
Load custID, Amount from .....
Here i want to change all the values of amount to zero when the status is equal to 'Inactive'. Can someone please help me out with this?