Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
clovati
Partner - Creator
Partner - Creator

comment by Excel variable

Hi everybody!

In excel I created this comment:

Capture.PNG

that is (note the words that go on new line):

vCommentoValOrdiniValore Ordini
(Fonte: Ordini online)

then in UI I obtain correctly this in a sheet:

5.PNG

but in other sheet I have this wrong:

Copia2.PNG

Any idea?

thank you!

5 Replies
marcus_malinow
Partner - Specialist III
Partner - Specialist III

Try this:

='Valore Ordini

' & $(vCommentoValOrdini)

Anil_Babu_Samineni

You must close with Single quotes and use like

='Display' & Variable

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
clovati
Partner - Creator
Partner - Creator
Author

I tried this:

='$(vCommentoValOrdini)'

and worked...

oscar_ortiz
Partner - Specialist
Partner - Specialist

Cristina,

Sounds like you may want something like this:

='Valore Ordini'

& Chr(013) &

'$(vCommentoValOrdini)'

The Chr(013) is a carriage return.

Good luck

Oscar

jmvilaplanap
Specialist
Specialist

Hi

Try to put it into single quotes '$(Variable)' then will be treated as a string and not like a formula that need to be evaluated.

Regards