Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
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'

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

Community Browser