topic Re: How to Handle Dimension where dimension values though same but are not proper ? in QlikView

How to Handle Dimension where dimension values though same but are not proper ?

shekhar_analyti — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

How to Handle Dimension where dimension values though same but are not proper ?

Shekar

Re: How to Handle Dimension where dimension values though same but are not proper ?

hector_munoz — Sat, 15 Apr 2017 06:09:53 GMT

Hi shektar,

In these cases the most common solution is to apply a text format function like Upper() (all characters in uppercase), Lower(all characters in lowercase) or Capitalize(first character in uppercase, the rest in lowercase). You have to take it into account when associating tables in a QlikView model.

Hope it serves!

Regards,
H

Re: How to Handle Dimension where dimension values though same but are not proper ?

swuehl — Sat, 15 Apr 2017 10:37:38 GMT

I agree, that with your sample data, some simple text function like Capitalize() should do what you need: Create a consistent value per country name.

If there are other deviations in spelling than case, you can also consider a mapping approach:

Data Cleansing