topic Re: Combining field values with disregard to capitalization in QlikView

Combining field values with disregard to capitalization

heathqm — Mon, 27 Jun 2022 19:53:59 GMT

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.

Re: Combining field values with disregard to capitalization

Or — Mon, 27 Jun 2022 20:59:56 GMT

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?

Re: Combining field values with disregard to capitalization

heathqm — Mon, 27 Jun 2022 21:17:51 GMT

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.

Re: Combining field values with disregard to capitalization

MarcoWedel — Mon, 27 Jun 2022 22:39:48 GMT

Your Upper() approach should work.

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