New to Qlikview - Expression with nested if's that can have multiple outcomes
I'm rather new to Qlikview and need help with an nested if within an expression. I'm pulling in a customer report and need to perform a check to make sure the columns are in sync. For example column A list the Customer Address from Application A, while column B lists the Customer Address from Application B. Column C would list Customer City from Application A while column D would list Customer City from Application B. This column check goes on about 6 levels deep (Customer address 1, customer address 2, City, State, Zip, Country).
I have no problem with a straight if statement that shows if 1 column is out of sync, but my problem is I need to show all out of sync items. A simple if statement would drop out after the first out of sync issue is found, while I need it to show all out of sync situations.
if ([A_STREET1_2] <> [B_STREET1_2], 'Business Review- Street Address 1 is Out of Sync', if ([A_STREET2_2] <> [B_STREET2_2], 'Business Review - Street Address 2 is Out of Sync', if ([A_STREET3_2] <> [B_STREET3_2], 'Business Review - Street Address 3 is Out of Sync', if ([A_CITY_2] <> [B_CITY_2], 'Business Review - City is Out of Sync', if ([A_COUNTRY_2] <> [B_COUNTRY_2], 'Business Review - Country is Out of Sync', if ([A_REGION_2] <> [B_REGION_2], 'Business Review - Region is Out of Sync'))))))