Convert the small letters into caps in a field in qliksense

[Kohli]

I have a field with batch id, the field contained both numeric, letters and special characters. letters are in both caps and small. I need when letters are in small, that converts into caps.

Ex:

BatchID:                o/p Table:  

ABC123-1              ABC123-1  

cdA123-2             CDA123-2

XYe1282-1           XYE1282-1

[PrashantSangle · Accepted solution]

use upper(). for details see on help menu
https://help.qlik.com/

Try to use help menu as much as you can

Regards,
Prashant Sangle

[pradosh_thakur · Accepted solution]

Upper(BatchID) as BatchID

[pradosh_thakur]

Have a look

https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunc...