I think I'm thinking about things to much, and have muddled my brain!!
I have three tables, all hold common fields, but one, 'Customer Number' as the link. My tables are Debt, Dashboard and Business Owner. In each of these tables I have a field that is named differently in each but is essentially the same, AC3. The AC3 changes depending on the customer number, and who in the business it is assigned too.
Rule is, that the AC3 to be assigned to the 'Customer' comes first from the 'Debt' table, if it can't be assigned from there, then it goes to the 'Business Owner', and then 'Dashboard'.
This, in English is what I want to achieve, but after 24 hours, I'm still not there!
If Debt_AC3 is null, or '95', look up Business_Owner_AC3, but if Business_Owner_AC3 is null, or '95', look up Dashboard_AC3, for anything other than null or '95', in the Debt_AC3, use the Debt_AC3.
I have this so far:
if(Debt_AC3='95', Business_Owner_AC3, Debt_AC3))
How do I add the extra rule, that if Business_Owner_AC3 is null, or '95', look up the Dashboard_AC3?
I thought a mapping might work, but the AC3 comes from three different tables, and when I tried, everything went haywire!
I've tried nesting another if in there, but Qlik said it was garbage!