Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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)