QlikView App Dev

[#1]

I would like to turn a long 1 line SET statement into a manageable 2 or 3 lines like so:

SET variable = "really really really really really really really really really really really really really really really really really really long variable"

to

SET variable = "really really really really really really really really really really really" &

                       "really really really really really really really long variable"

Is there a way to do this with the SET statement or should I just modify the above to a let statement?

thanks,

rich

[#2]

SET cannot evaluate and LET is used to evaluate.

As you have &, I think you dont have an option,other than making it to LET.

[#3]

I'm using & as an example as a possible delimiter. I don't what the right delimiter is, (or even if there is one).

I actually don't want to evaluate the string as it is full of formulas and I want it to appear as string literal for a field in a LOAD statement.

[#4]

Can you give me some more info on your requirement.

[#5 · Accepted solution]

You can have carriage returns in a set statement but they will be included as part of the variable value. For example:

SET variable =really really really really really really really really really

really really really really really really really

really really long variable;

If you need to remove the return characters you can try to use the replace function (I don't know if you need use chr(10), chr(13), or both as the search string to replace).

[#6]

Thanks. This works