Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
delbooth
Contributor II
Contributor II

text and case sensitive

Hi.

I would like to sum a field Quantity_ Collected from the field Account_Name which can have the text 00012 PAUL or 00012 paul so it gives me a sum for Paul ignoring the fact some are in upper and some lowercase.

Thanks

Del

8 Replies
christophebrault
Specialist
Specialist

Hi,

If possible, the goodway to do this is to Upper or Lower your Account_Name in the script

Lower(Account_Name) as Account_Name

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin
agigliotti
Partner - Champion
Partner - Champion

you can use the below calculated dimension:

Upper(dimension_name)

lironbaram
Partner - Master III
Partner - Master III

hi

you can use Upper() function on your field

so all text will be in upper case for this function

PrashantSangle

use wildmatch()

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Chanty4u
MVP
MVP

try may be

Capitalize(lower(field))


or


Capitalize(upper(field))

delbooth
Contributor II
Contributor II
Author

Thanks for that, I have now all text in capitals.  To finish it off how do I sum Account_Number that contains the text PAUL when it can be 00012 PAUL, 0014 PAUL, 0015PAUL in the field.

I have tried

Sum({<[Account Number]= {'*PAUL*'}>} [Quantity Advised])

OmarBenSalem

put it btwn double quotes; it will work wether it's upper or lower case

Sum({<[Account Number]= {"PAUL"}>} [Quantity Advised])

OmarBenSalem

please refer to :

Quotes in Set Analysis