New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Not applicable

Help with i number in a textobjekt

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

1 Solution

Accepted Solutions
Not applicable

Re: Help with i number in a textobjekt

Hello!

I solved the problem

= 'Outcome' & sum ([sum]) & Chr (10) & 'Ultimate goal: xxx'

show my solution above

thanks for the help

5 Replies
MVP

Re: Help with i number in a textobjekt

Not sure if I understood correctly, maybe like:

= 'Outcome: (' & sum([Sum]) & ')'

i.e. concatenate two string literals and the result of the sum expression.

Not applicable

Re: Help with i number in a textobjekt

Hello again!

Now I have the formula = 'Outcome' & sum ([sum]) & 'Ultimate goal: xxx

But I need to make a line break at the Ultimate goal, how do I do it?

Not applicable

Re: Help with i number in a textobjekt

Hello!

I solved the problem

= 'Outcome' & sum ([sum]) & Chr (10) & 'Ultimate goal: xxx'

show my solution above

thanks for the help

Not applicable

Re: Help with i number in a textobjekt

Hi,

try this......

= 'Outcome' & sum ([sum]) & chr(13) & 'Ultimate goal: xxx'

Contributor III

Re: Help with i number in a textobjekt

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])