Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Replace Function with $

Hello

I have a textbox that contains the contents of a variable, var_calls. The variable contains the text "$(time)" which I need to remove from the value shown in the text box. So I've written

=replace(var_calls, '$(time)', '')

But this doesn't work because QV thinks that $(time) in the above expression is a referenceto a variable, rather than a literal string. So it doesn't work.

Is there a way to prevent the $ sign making QV think it's a variable?

Hope this makes sense.

James

Labels (1)
1 Reply
Not applicable
Author

James try creating a variable and putting into it the string $(time) and referencing that variable in the replace command