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

Announcements
Join us in Toronto Sept 9th 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