Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Writing with formulas

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,

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Sure:

='The amount is ' & varProd

View solution in original post

3 Replies
swuehl
MVP
MVP

Sure:

='The amount is ' & varProd

jaimeaguilar
Partner - Specialist II
Partner - Specialist II

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

fkeuroglian
Partner - Master
Partner - Master

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