Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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

'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.

Tags (1)
1 Solution

Accepted Solutions
er_mohit
Honored Contributor II

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

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

hopr it helps

sorry my mistake remove that equal

2 Replies
er_mohit
Honored Contributor II

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

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

hopr it helps

sorry my mistake remove that equal

Not applicable

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

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