QlikSense-Rename Field to Contain '$'-sign

JustinDallas · ‎2023-02-23

Hello Folks,

Is there a way to rename a field so that it contains a $-sign? I've got the following test script and it seems to try to expand the dollar-sign.

[Test Table]:
Load * Inline
[
'Dummy Column'
1
]
;
Rename Field [Dummy Column] To 'Awarded $(by Compensation)'
;
Exit Script
;

I would like to see the field name say Awarded $(by Compensation)

I've tried using variables but to no avail.

Any help is greatly appreciated.

henrikalmen · ‎2023-02-23

I'm not sure this will work, or if it is even allowed to have a dollar sign in a field name, but try this:

rename Field [Dummy Column] To [$(='Awarded '&chr(63)&'(by Compensation)')];

BrunPierre · ‎2023-02-23

How about creating a variable as such,

LET vRenameField = 'Awarded '&chr(36)&chr(32)&'(by Compensation)';

and then reference the variable in the rename syntax.

Rename Field [Dummy Column] To '$(vRenameField)';

Mathumitha · ‎2023-02-24

Try this,

Rename Field [Dummy Column] to [Awarded $ (by Compensation)];