Discussion board where members can get started with QlikView.
I need help in a text object.Outcome: (= Sum ([Sum]))Ultimate goal: xxx
But how do I get it so that I get a calculated variable between text variables.
I select the text so no way to type "or is there some other way, I need help stuck
Go to Solution.
Hello!I solved the problem= 'Outcome' & sum ([sum]) & Chr (10) & 'Ultimate goal: xxx'show my solution abovethanks for the help
Not sure if I understood correctly, maybe like:
= 'Outcome: (' & sum([Sum]) & ')'
i.e. concatenate two string literals and the result of the sum expression.
Hello again!Now I have the formula = 'Outcome' & sum ([sum]) & 'Ultimate goal: xxxBut I need to make a line break at the Ultimate goal, how do I do it?
= 'Outcome' & sum ([sum]) & chr(13) & 'Ultimate goal: xxx'
You can either use the function chr(13) making the expression look like this
='Outcome' &sum ([sum]) & chr(13) & chr(13) & 'Ultimate goal: ' & sum ([sum])
Or you can just use '' across lines, like
='Outcome' &sum ([sum]) & '
Ultimate goal: ' & sum ([sum])