QlikView read data as Case Sensitive?

[#1]

Hi All,

I am a new learner of QlikView. I come with a question when I am building a new  Dashboard for the customer.

I find QlikV seems iew reading data as  Case Sensitive approach which caused some data duplication issue to my works.

As shown in below diagram, There are two different values in Fields Selection Box, 'Sea' & 'SEA'.

In operation perspective, it's exactly the same set of data while it is different data in QlikView.

May I know  is there a way that we can set the program to read data as case-insentive?

Thanks.

Hasson

[swuehl]

No, I don't think so.

But you can convert your values using string functions:

LOAD

Upper(Mode) as Mode,

...

FROM ...;

to convert Sea to SEA (leaving original SEA and AIR as is),

or

LOAD

Capitalize(Mode) as Mode,

...

FROM ...;

to convert SEA to Sea and AIR to Air (leaving original Sea as is).

In both cases, you should get only two distinct values in Mode field.

Hope this helps,

Stefan

[#3]

If this can occur in multiple fields (across different tables), it is also an idea to put the following instruction in your script before loading any data:

     force case upper;

This will make Qlikview turn all values in every field in upper cases and so you can never get into this problem again.

Regards,

Yves

[#4]

i too think that wont happen in qlikview.

On converting all values to Capital Letter in a particular field using the 'upper(var) as Name', this wont hapen.

Thanks

Renjith Kumaran