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

Announcements
Join us in Zurich on Sept 24th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
abhi1693r
Contributor II
Contributor II

Get a single number displayed with a heading

I have to simply get one calculated field/expression in a box without any outlines or box, just a number. 

What object should I use ?

Example attached.

 

 

10 Replies
diego_a_barboza
Creator
Creator

However, in order to use it, you may require to enclose it in $() for evaluation.

For instance, if you have the following variables:

  • set v_sales_amount = 'sum(sales)'
  • set v_sales_units = 'sum(units)'

you can use them as expressions on this way on any chart:

  • =$(v_sales_amount )  // In order to express sales
  • =$(v_sales_units )  // In order to express quantity of unit sold
  • =$(v_sales_amount )  / $(v_sales_units ) // In order to express average price of unit sold

And you can even nest more complex functions.