topic Re: How do I display text and an expression in a text object? in QlikView

How do I display text and an expression in a text object?

Thu, 07 Mar 2013 12:20:41 GMT

'AVG TIME:' & =time(avg(aggr(Interval(max(EventDate)-min(EventDate), 'mm:ss'), SessionID)),'mm:ss')

This for example gives me :

'AVG TIME:' & =time(avg(aggr(Interval(max(EventDate)-min(EventDate), 'mm:ss'), SessionID)),'mm:ss')

When I would like my output of the text object to read

AVG Time: 30:00

for example...

It seems successful if I do this the other way around, e.g.

=time(avg(aggr(Interval(max(EventDate)-min(EventDate), 'mm:ss'), SessionID)),'mm:ss') & 'Is the avg time'

why would the order matter so much? Seems very quirky.

er_mohit — Thu, 07 Mar 2013 12:33:19 GMT

='AVG TIME ' & time(avg(aggr(Interval(max(EventDate)-min(EventDate), 'mm:ss'), SessionID)),'mm:ss')

hopr it helps

sorry my mistake remove that equal

Thu, 07 Mar 2013 12:35:12 GMT

Nor working, it's not happy with the second = in the expression.