Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
josephinetedesc
Creator III
Creator III

What has changed in Excel/Qlikview re uppercase recognition?

Hi in December I was able to check in Excel that the contents of 2 cells were the same.  For example the filter would show  SKIN, or skin as different.  This meant that the data going into QlikView was "clean".  I think this has now changed?  Has anyone else noticed this "new feature" in Excel   ... Excel version: Excel 2013

Jo

Capture.PNGCapture1.PNG

1 Solution

Accepted Solutions
bill_markham
Champion III
Champion III

If you want QlikView to make them all the same case wise then look at these QlikView functions :

upper(textexpression)

Forces upper case for all data in the expression.

Example:

upper( 'abcD' ) returns 'ABCD'.

lower( textexpression )

Forces lower case for all data in the expression.

Example:

lower( 'abcD' ) returns 'abcd'.

capitalize(s )

Returns the string s with all words capitalized.

Example:

capitalize ('my little pony') returns 'My Little Pony'

capitalize ( 'AA bb cC Dd') returns 'Aa Bb Cc Dd'

[Pasted from QV Desktop Help]

View solution in original post

4 Replies
bill_markham
Champion III
Champion III

May be better to ask on an Excel forum.

NareshGuntur
Partner - Specialist
Partner - Specialist

Yes. I have suffered this.

It shows as case insensitive.

josephinetedesc
Creator III
Creator III
Author

Hi Bill

I only became aware because QlikView showed the different cases as different options.  I kept trying to find out why the poblem was occuring.

Jo

bill_markham
Champion III
Champion III

If you want QlikView to make them all the same case wise then look at these QlikView functions :

upper(textexpression)

Forces upper case for all data in the expression.

Example:

upper( 'abcD' ) returns 'ABCD'.

lower( textexpression )

Forces lower case for all data in the expression.

Example:

lower( 'abcD' ) returns 'abcd'.

capitalize(s )

Returns the string s with all words capitalized.

Example:

capitalize ('my little pony') returns 'My Little Pony'

capitalize ( 'AA bb cC Dd') returns 'Aa Bb Cc Dd'

[Pasted from QV Desktop Help]