Discussion Board for collaboration related to QlikView App Development.
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?
Capitalize(FIELDNAME) as FIELDNAME,
in your load script.
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.
Or have a look at
Thanks a lot, It works
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:
Autonumber(lower(Name)) as NameCounter
Use Count(distinct NameCounter) in your expression.
You are welcome!
If your request is resolved then please close this thread:
Qlik Community Tip: Marking Replies as Correct or Helpful