Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
In my QlikView project I import an excel file.
This excel file contains strings that I use throughout the project.
In some of these strings, I would like to reference a variable from my QlikView project so I don't have to cut the string into multiple parts.
The string looks something like this: "this is a string that contains a vVariable in the middle fo the sentence."
Is it possible to replace "vVariable" with the variable in QlikView? If so, how do I need to reference the variable in my excel file?
you didn't provide enough detail.
here for example I created a text with = "this is a string that contains a vVariable in the middle of the string"
I created a variable with the value vVariable =1
the expression
=replace(text,'vVariable',vVariable)
can give us "this is a string that contains a 1 in the middle of the string"
??
can you share an example
an example is one cell with the string "this is a string that contains a vVariable in the middle of the string" where vVariable is the variable
you didn't provide enough detail.
here for example I created a text with = "this is a string that contains a vVariable in the middle of the string"
I created a variable with the value vVariable =1
the expression
=replace(text,'vVariable',vVariable)
can give us "this is a string that contains a 1 in the middle of the string"
??
Annie, did Taoufiq's last post get you what you needed? If so, do not forget to return to the thread and on his last post, use the Accept as Solution button to give him credit for the help, let other Members know it worked and close the thread. If you did something else, please consider posting that, mark it to close things out, and if you are still working on things, let us know where you stand and what you still need. More details would be helpful, as I am having a bit of a hard time understanding exactly what it is you wish to do too. Attaching a sample QVW would be very helpful on this one, so we can see exactly what you have going.
Regards,
Brett