Analog UCASE in QV

[Anonymous]

Hi,

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

All letters should be capital.

For example:

before  asdfgh          after    ASDFGH

Thanks,

[johnca]

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]

Thanks,

But I need all letters capital

[johnca · Accepted solution]

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

[Anonymous]

Thank you so much