topic Writing with formulas in QlikView

Writing with formulas

Wed, 12 Feb 2014 19:32:54 GMT

Hello,

I was wondering if its possible that in a Text object you can write like:

The Amount is: varProd

Where varProd is a variable that changes value.

I currently know that to wrtie the value you can do =varProd and it'll display the number, but is it possible to have a mix of text and variables or formulas, like in C++ or java.

Any ideas?

thanks,

Re: Writing with formulas

swuehl — Wed, 12 Feb 2014 19:36:02 GMT

Sure:

='The amount is ' & varProd

Re: Writing with formulas

jaimeaguilar — Wed, 12 Feb 2014 19:39:16 GMT

Hi,

You can concatenate static text with variable values. Just like you said in a text box try this:

='The Amount is: ' & $(varProd)

just to mention, the $() is used when you want to evaluate the content of a variable, if you type just varProd, QlikView will return literally the text written in that variable.

regards

Re: Writing with formulas

fkeuroglian — Wed, 12 Feb 2014 19:40:39 GMT

Yes you can as Swuehl indicated you, and you can use the function num to have the correct decimals and extension number

num( var,'###.###,')

good luck!

Fernando