Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Replace Function with $


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.


1 Reply
Not applicable

Replace Function with $

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

Community Browser