Merging two dimensions into one

[#1]

Hi - I have two dimensions in the base data Excel file,and I want to merge them so they both display as one name.

Dimensions I have:

North West

North East

Dimension  I want:

North

Is there a way to do this in Qlikview rather apart from going into the Excel files and fixing the names there? Kindly help!

[#2]

The IF-statement is case-sensitive.

You can use lower([Region]) to check for the string you're looking for:

if (lower([Region])='assurance north west' or lower([Region])='assurance north east', 'Assurance North', [Region]) as [Region]

[#3]

Can you upload a sample application...............