Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Sure:
='The amount is ' & varProd
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
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