topic Re: Get a single number displayed with a heading in QlikView

Get a single number displayed with a heading

abhi1693r — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Get a single number displayed with a heading

fkeuroglian — Wed, 10 Jul 2019 15:54:05 GMT

Text Box adding some format

Font
Size
Color
TEXT( Total: 12345) addint string to the numbers to concatenate values and string

Hope Help

Fernando

Re: Get a single number displayed with a heading

abhi1693r — Wed, 10 Jul 2019 18:03:40 GMT

Hi Fernando,

Thanks for the reply.

I did not understand the 4th point. I actually have a variable I have defined that I need to display and not a random number.

Re: Get a single number displayed with a heading

fkeuroglian — Wed, 10 Jul 2019 18:20:02 GMT

Hi, example

='Total Value:' & $Variable

Hope helps

Fernando

Re: Get a single number displayed with a heading

abhi1693r — Wed, 10 Jul 2019 18:32:57 GMT

What 'Action' should I select for the text box?

Re: Get a single number displayed with a heading

diego_a_barboza — Wed, 10 Jul 2019 19:18:10 GMT

You are not required to choose any action unless you are planning to add some interactivity to that object.

If you don't want to see any borders, then choose the background color as white > transparent 100% and don't select any border on the Layout tab.

Re: Get a single number displayed with a heading

abhi1693r — Wed, 10 Jul 2019 19:31:32 GMT

okay, but how do I get a calculated value from an already defined variable or expression in that box?

Re: Get a single number displayed with a heading

fkeuroglian — Wed, 10 Jul 2019 22:00:40 GMT

Hi, only put the name of the variable that you previous calculate

for example put in the text object:

=variableName

Re: Get a single number displayed with a heading

abhi1693r — Wed, 10 Jul 2019 22:13:03 GMT

One last query, if I create a variable, can I use it while creating another variable?

Re: Get a single number displayed with a heading

jimmygohhanjie — Thu, 11 Jul 2019 07:01:46 GMT

Yes, you can

Re: Get a single number displayed with a heading

diego_a_barboza — Thu, 11 Jul 2019 12:48:19 GMT

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.