Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

delbooth
New 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
christophebraul
Contributor III

Re: text and case sensitive

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

agigliotti
Honored Contributor II

Re: text and case sensitive

you can use the below calculated dimension:

Upper(dimension_name)

lironbaram
Honored Contributor II

Re: text and case sensitive

hi

you can use Upper() function on your field

so all text will be in upper case for this function

Re: text and case sensitive

use wildmatch()

Regards,

Regards,
Prashant Sangle
sureshqv
Esteemed Contributor III

Re: text and case sensitive

try may be

Capitalize(lower(field))


or


Capitalize(upper(field))

delbooth
New Contributor II

Re: text and case sensitive

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
Esteemed Contributor

Re: text and case sensitive

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

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

omarbensalem
Esteemed Contributor

Re: text and case sensitive

please refer to :

Quotes in Set Analysis