topic Re: comment by Excel variable in QlikView

comment by Excel variable

clovati — Wed, 25 Nov 2020 16:16:04 GMT

Hi everybody!

In excel I created this comment:

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

vCommentoValOrdini

Valore Ordini
(Fonte: Ordini online)

then in UI I obtain correctly this in a sheet:

but in other sheet I have this wrong:

Any idea?

thank you!

marcus_malinow — Tue, 11 Jul 2017 14:25:58 GMT

Try this:

='Valore Ordini

' & $(vCommentoValOrdini)

Anil_Babu_Samineni — Tue, 11 Jul 2017 14:27:51 GMT

You must close with Single quotes and use like

='Display' & Variable

clovati — Tue, 11 Jul 2017 14:32:12 GMT

I tried this:

='$(vCommentoValOrdini)'

and worked...

oscar_ortiz — Tue, 11 Jul 2017 14:57:01 GMT

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 — Tue, 11 Jul 2017 15:47:58 GMT

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