Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

stekol61
Contributor

Average duration i graph

Hi!

The example below shows duration (TTR Event) per ID for one week.

Some ID's are missing duration values.

I can get a correct average value in a table.

The problem is is when I try to present average duration per week in a graph. E.g. I want to see '19:24' for week 45 in the graph

The TTR Event is calculated as this: '=if (source='Event', TTR, )'

1 Solution

Accepted Solutions
MVP
MVP

Re: Average duration i graph

Create your calculated dimension in the script... it is doing as simple as this

Week(start_date) as Week

and then use that in your Aggr() function

3 Replies
MVP
MVP

Re: Average duration i graph

May be this

Avg(Aggr(Only({<source = {'Event'}>} TTR), ID, Week, source, create_date))

stekol61
Contributor

Re: Average duration i graph

Hi!

It doesn't work, I get no result.

'Week' is a calculatet value. '=Week (start_date)' so i added this to your expression but it doesn't help. Stil no result in the graph

MVP
MVP

Re: Average duration i graph

Create your calculated dimension in the script... it is doing as simple as this

Week(start_date) as Week

and then use that in your Aggr() function