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: 
Not applicable

How to manage case sensitive data.

How to manage data if they are case sensitive.

Eg: My excel file has Ranjit and ranjit. Now the count of this two are different? How can I make them count as same?

5 Replies
swuehl
MVP
MVP

Maybe use

LOAD

     Capitalize(FIELDNAME) as FIELDNAME,

in your load script.

edit:

If you want to convert all values to lower case, use Lower(FIELDNAME) instead.

Basically, use string functions to transform your data values to a consistent case use.

swuehl
MVP
MVP

Or  have a look at

Data Cleansing

Not applicable
Author

Thanks a lot, It works

Not applicable
Author

Follow Stefan approach to convert the data into capitalize or lower or Upper. But do you need to show values as it is in the source but need to count only once then add new field counter like below:

Load

     Name,

     Autonumber(lower(Name)) as NameCounter

..

Use Count(distinct NameCounter) in your expression.

swuehl
MVP
MVP

You are welcome!

If your request is resolved then please close this thread:

Qlik Community Tip: Marking Replies as Correct or Helpful