topic Re: QlikView read data as Case Sensitive? in QlikView

QlikView read data as Case Sensitive?

Mon, 04 Feb 2013 10:20:58 GMT

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

Re: QlikView read data as Case Sensitive?

swuehl — Mon, 04 Feb 2013 10:31:51 GMT

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),

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

Re: QlikView read data as Case Sensitive?

Mon, 04 Feb 2013 10:45:55 GMT

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

Re: QlikView read data as Case Sensitive?

Mon, 04 Feb 2013 11:47:00 GMT

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