Discussion Board for collaboration related to Creating Analytics for QlikView.
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 try creating a variable and putting into it the string $(time) and referencing that variable in the replace command