How to display a variable's original string value with a single quote and/or a variable $ placeholder

Thomas_Spitzer — Tue, 12 Jan 2021 17:40:28 GMT

I define following variables:
Let myVar1 = 'this var contains a single quote ' & Chr(39) & ' character.';
Let myVar2 = 'this var contains a ' & Chr(36) & '(anotherVar) placeholder.';

Then the resulting string value of myVar1 will be:
this var contains a single quote ' character.

And the resulting string value of myVar2 will be:
this var contains a $(anotherVar) placeholder.

So far, so good.

Now I want to display the variables string value as information for the user in a qlik sense app (for example in an text & image visualization). The result should be exacly as the var string values above with the single quote an the not replaced $(anotherVar) expression, something like this:

The string value of myVar1 is: this var contains a single quote ' character.
The string value of myVar2 is: this var contains a $(anotherVar) placeholder.

The following (of course) does not work:

= 'The string value of myVar1 is: ' & '$(myVar1)'
= 'The string value of myVar2 is: ' & '$(myVar2)'

I've looked intensively but did not found any way to do this.

Any solution?

Re: How to display a variable's original string value with a single quote and/or a variable $ placeholder

Saravanan_Desingh — Tue, 12 Jan 2021 19:35:13 GMT

May be try like this.

Set myVar1 = 'this var contains a single quote ' & Chr(39) & ' character.'; Set myVar2 = 'this var contains a ' & Chr(36) & '(anotherVar) placeholder.'; = 'The string value of myVar1 is: ' & '$(myVar1)' = 'The string value of myVar2 is: ' & '$(myVar2)'

Set myVar1 = 'this var contains a single quote ' & Chr(39) & ' character.'; Set myVar2 = 'this var contains a @(anotherVar) placeholder.'; Let myVar3 = Replace(myVar2,'@','$'); = 'The string value of myVar1 is: ' & '$(myVar1)' = 'The string value of myVar2 is: ' & '$(myVar3)'

topic Re: How to display a variable's original string value with a single quote and/or a variable $ placeholder in App Development

How to display a variable's original string value with a single quote and/or a variable $ placeholder

Re: How to display a variable's original string value with a single quote and/or a variable $ placeholder