topic Re: DATA Quality in QlikView

DATA Quality

Tue, 11 Feb 2014 09:16:32 GMT

Hi Everyody ,

I have a little problem , i want to contrôle the quality of my Data , for example

2 rows :

GASQUET laurent

gasquet LAURENT

For me is the same rows but QLIK VIEW Loaded me GASQUET laurent and gasquet LAURENT

So someone have idea to get some controle of my data

Thank You

ThornOfCrowns — Tue, 11 Feb 2014 09:19:11 GMT

Answered in your other thread:

Tue, 11 Feb 2014 10:26:13 GMT

Use Capitalize function while loading data.

mahesh_agrawal — Tue, 11 Feb 2014 10:41:34 GMT

Hi,

If you need ur output as Gasquet Laurent', then use Capitalize().

If u want it as 'GASQUET LAURENT', then upper(Capitalise(Name)).

Sokkorn — Tue, 11 Feb 2014 10:42:07 GMT

Hi,

We can use Lower(), Upper() and Capitalize() to do this job.

Example:

Lower( 'abcD' ) -> returns abcd

Upper( 'abcD' ) -> returns ABCD

Capitalize( 'AA bb cC Dd') -> returns Aa Bb Cc Dd

Regards,

Sokkorn

ashwanin — Tue, 11 Feb 2014 10:47:00 GMT

Hi you can do this by using function Capitalize.

It will make your data proper and help in improving the quality. You just need to put below in your script.

Capitalize(your_field_name) as your_field_name

Tue, 11 Feb 2014 10:58:38 GMT

Check the attached QV.