topic Import string with variable in QlikView

Import string with variable

AnnieV — Sat, 16 Nov 2024 19:11:54 GMT

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?

Re: Import string with variable

Taoufiq_Zarra — Fri, 31 Jan 2020 19:13:33 GMT

can you share an example

Re: Import string with variable

AnnieV — Wed, 12 Feb 2020 14:11:06 GMT

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

Re: Import string with variable

AnnieV — Tue, 18 Feb 2020 08:24:19 GMT

@Taoufiq_Zarra

Re: Import string with variable

Taoufiq_Zarra — Tue, 18 Feb 2020 08:34:47 GMT

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"

Re: Import string with variable

Brett_Bleess — Mon, 24 Feb 2020 22:18:06 GMT

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