Replace Function with $

Thu, 09 Jun 2011 15:03:38 GMT

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

Replace Function with $

Thu, 09 Jun 2011 15:12:30 GMT

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

topic Replace Function with $ in QlikView

Replace Function with $

Replace Function with $