topic Expressions on a Text Object in QlikView

Expressions on a Text Object

Wed, 25 Nov 2020 16:16:04 GMT

Hi community

I want to put in an expression in a text object ,but it is not displaying it shows Dash . i'm using a HourAllocated field and there's no Calculations that needs to be done , how can i achieve this ?:

Regards

Innocent

Re: Expressions on a Text Object

sunny_talwar — Mon, 04 Apr 2016 12:41:32 GMT

Are there multiple HourAllocated available for selection? If there are, then when you put HourAllocated in a text box, then QV doesn't know when HourAllocated to show. Do you want to show there Avg or Sum or Min or Max may be? Then add that aggregation -> Max(HourAllocated) for example

Re: Expressions on a Text Object

MindaugasBacius — Mon, 04 Apr 2016 12:48:01 GMT

In an expression you need to use one of aggregation functions:

https://community.qlik.com/blogs/qlikviewdesignblog/2014/06/16/use-the-aggregation-functions

Without aggregation you just set the array - not the single value.

Re: Expressions on a Text Object

Anonymous — Mon, 04 Apr 2016 13:04:14 GMT

Does it contain list of values ? Are you trying to display multiple values ?

if it is u r looking for try this .

Concat(Chr(10)&HourAllocated)