topic Writing Expression in Text Object in QlikView

Writing Expression in Text Object

Sat, 19 Mar 2011 18:30:08 GMT

Is there a way to write an expression in the Text Object box. For example I created a Text Object and I wanted it to display Value = Sum(Field). i want it to calculate the Sum(Field) and it does not.

Writing Expression in Text Object

deepakk — Sat, 19 Mar 2011 19:17:08 GMT

hi,

YOu have to write

= SUm(Field).

"=" sign is imp in text object

Writing Expression in Text Object

Sat, 19 Mar 2011 20:11:29 GMT

thanks for your response. But is there a way i can get the word "Value" to show up as well? For example I want my output to have the word "Value" then display the Sum(field).

Writing Expression in Text Object

Miguel_Angel_Baeyens — Sat, 19 Mar 2011 20:20:23 GMT

Hello,

Do the following (it's valid for expression labels, button texts, object captions and so)

='Value: ' & Sum(Value)

Hope that helps.

Writing Expression in Text Object

Sat, 19 Mar 2011 20:53:45 GMT

Thanks a lot.

Re: Writing Expression in Text Object

kumarravi — Wed, 23 Mar 2022 17:20:12 GMT

You can use:

= 'Date : ' & =now()

' ' & expression
& operation will act as a concatenator