Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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]
May be better to ask on an Excel forum.
Yes. I have suffered this.
It shows as case insensitive.
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
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]