Combining field values with disregard to capitalization

[heathqm]

Hello I am reading data in from an excel sheet.

I have a field labeled 'Title' and there are values that are in all capitals and some that are not. Qlik is not combining these values. 

Example of values: 'PROCUREMENT, LL' or 'Procurement, LL'

I have tried Capitalize(Title); Upper(Title); Lower(Title) in the load script and none of the listed is working. 

[Or]

Perhaps I misread your post, but - why would Qlik combine two rows just because they have an identical value in one specific field?

If you use e.g.

Load Distinct Upper(Title)

From YourTable;

Then duplicate values of Title should be removed, but based on your description that doesn't seem to be the case?

[heathqm]

I don't necessarily want to combine the two rows; I want Qlik to identify the field value as the same despite the case of the letters.

If there are two rows like this:

Title = Procurement, LL; Amount = $4

Title = PROCUREMENT, LL; Amount = $7

Then I would want to sum the amount across the title. Well Procurement, LL and PROCURMENT, LL are the same title just different capital case so I would want the amount to be $11. But right now its treating them as two different cases.

Like stated above, Upper(Title) does not work. Its keeping both as separate and not working.

[MarcoWedel]

Your Upper() approach should work.

Please post some sample data and your load statement to demonstrate the issue.