topic Analog UCASE in QV in QlikView

Analog UCASE in QV

Anonymous — Thu, 28 Nov 2013 16:13:08 GMT

Hi,

Do you know analog command UCASE (SQL) in QlikView?

All letters should be capital.

For example:

before asdfgh after ASDFGH

Thanks,

johnca — Thu, 28 Nov 2013 16:15:50 GMT

That would be done best in script as; Upper(<Field>) as Field, and yields ASDFGH.

Capitalize(<Field>) as Field would yield Asdfgh.

HTH,

John

Anonymous — Thu, 28 Nov 2013 16:17:12 GMT

Thanks,

But I need all letters capital

johnca — Thu, 28 Nov 2013 16:21:43 GMT

Then use the first example...Upper(<Field>) as Field.

Anonymous — Thu, 28 Nov 2013 16:34:44 GMT

Thank you so much