Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Ignore difference between small and capital letters

Hi,

When creating a script which uses parts of the excel-filename as identification (all the files have the same filename-structure), QV differentiates between capital and small letters. Although they are the same and this difference should be ignored.

E.g.: "LETTER" doesn't equal "letter" during upload.

How can I include this in the script ?

Thanks in advance.

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Use upper() and lower() functions in your script. so that you can convert your text data either in upper case or lower case format.

Eg:

Upper(Field_Name) as Field_Name

View solution in original post

2 Replies
Highlighted

Use "Upper" keyword to make all words equal ...

Highlighted
Partner
Partner

Use upper() and lower() functions in your script. so that you can convert your text data either in upper case or lower case format.

Eg:

Upper(Field_Name) as Field_Name

View solution in original post