topic How to manage case sensitive data. in QlikView

How to manage case sensitive data.

Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: How to manage case sensitive data.

swuehl — Wed, 14 Dec 2016 11:45:55 GMT

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.

Re: How to manage case sensitive data.

swuehl — Wed, 14 Dec 2016 11:46:34 GMT

Or have a look at

Data Cleansing

Re: How to manage case sensitive data.

Wed, 14 Dec 2016 12:38:11 GMT

Thanks a lot, It works

Re: How to manage case sensitive data.

Wed, 14 Dec 2016 14:47:15 GMT

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.

Re: How to manage case sensitive data.

swuehl — Wed, 14 Dec 2016 20:55:11 GMT

You are welcome!

If your request is resolved then please close this thread:

Qlik Community Tip: Marking Replies as Correct or Helpful