topic Re: Lower case becomes upper case? in QlikView

Lower case becomes upper case?

Tue, 19 Mar 2013 12:37:59 GMT

Hi, I am new to QV and I have a problem when writing script in the script editor. When I for example write Date, it turns out as DATE and hence gives me problems when I want to use it as key. I have tried to use the Edit functions to change it but have not managed, my best guess is that there is a setting somewhere that needs to be changed. Someone who knows?

Thank you in advance

Re: Lower case becomes upper case?

hic — Tue, 19 Mar 2013 22:10:11 GMT

There is nothing in QlikVIew that would do this. But I have seen ODBC drivers that returns field names in UPPER case no matter what you write in the script...

Is it in a SELECT statement or in Load statement?

HIC

Re: Lower case becomes upper case?

Wed, 20 Mar 2013 10:54:42 GMT

It is in a select statement

//Emelie

Från: Henric Cronström

Skickat: den 19 mars 2013 23:10

Till: Emelie Nilsson

Ämne: - Re: Lower case becomes upper case?

QlikCommunity<http://community.qlik.com/index.jspa>

Re: Lower case becomes upper case?

created by Henric Cronström<http://community.qlik.com/people/hic> in Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/324007#324007>

Re: Lower case becomes upper case?

Anonymous — Wed, 20 Mar 2013 11:02:08 GMT

it do not happens automaticall unless you rename a field

date as DATE?

are not you using UPPER Function?

Regards,

anant

Re: Lower case becomes upper case?

sushil353 — Wed, 20 Mar 2013 11:45:52 GMT

Please post your sample application

Re: Lower case becomes upper case?

Thu, 21 Mar 2013 07:40:57 GMT

My select statement looks like this

ODBC CONNECT TO MOVEX_MVXCDTAAPRD (XUserId is bXKNaVFMWDbSGRB, XPassword is bXcIUURNWLYWGED);

SQL SELECT EZACQT,

EZACTY,

EZAIT1,

EZAIT2 as Division,

EZAIT3 as Avdelning,

EZAIT4,

EZAIT5 as Orsakskod,

EZAIT6,

EZAIT7 as Ordernummer,

EZANBR,

EZCHID,

EZCHNO,

EZCONO,

EZDIVI,

EZERCD,

EZEVEN,

EZFACI,

EZFSRC,

EZITNO as Artikelnummer,

EZLMDT,

EZLMTS,

EZRGDT,

EZRGTM,

EZSENO,

EZTFAM,

EZTRDT as Date,

EZVONO,

EZVSER,

EZYEA4,

EZACAM as Belopp

FROM KAVLI.M3EDBPRD.CINACC

WHERE EZYEA4=2013 AND EZAIT1='4061' AND EZDIVI='020' AND EZEVEN='MM020'

But in the Table viewer it becomes upper case and to key with MITMAS I had to change Artikelnummer in MITMAS to upper case

Från: sushil kumar

Skickat: den 20 mars 2013 12:46

Till: Emelie Nilsson

Ämne: - Re: Lower case becomes upper case?

QlikCommunity<http://community.qlik.com/index.jspa>

Re: Lower case becomes upper case?

created by sushil kumar<http://community.qlik.com/people/sushil353> in Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/324265#324265>

Re: Lower case becomes upper case?

hic — Thu, 21 Mar 2013 07:55:31 GMT

This means that your ODBC driver always returns upper case. If you want lower case you will need to use a preceding load (See http://community.qlik.com/blogs/qlikviewdesignblog/2013/03/04/preceding-load)

HIC