I can't share a QVW but here is the load statement I have, of course I'm getting an "Invalid Expression" error on it.
Load Tax_ID_Number, if(Max(MTG)>0, "Address_ID", if(Max(Pymt)>0, "Address_ID", mode("Address_ID"))) as "Address_ID" Resident Addrlink1 Group by Tax_ID_Number;
I don't want to add "Address_ID" to the group by because it doesn't give me the expected results. I need to have only one "Address_ID" associated with each unique "Tax_ID_Number". I need that "Address_ID" to be from the record that contains a value > 0 for "MTG", if one doesn't exist then check for a value > 0 for "Pymt" and use the "Address_ID" from that record, and if it doesn't exist use the mode("Address_ID") for that "Tax_ID_Number". I'm thinking maybe variables might present an answer, but I struggle with using variables.