Expressions on a Text Object

[#1]

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

[sunny_talwar]

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

[MindaugasBacius]

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.

[Anonymous]

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)