topic Re: Make an avg on 2 dates with a distinct variable in QlikView

Make an avg on 2 dates with a distinct variable

Thu, 04 Apr 2013 13:54:31 GMT

I'm new to qlikview and have a problem with a chart. I want to show the average time between 2 dates and use this expression:

round(Avg((end_date+end_time)-(start_date+start_time)),0.01)

It works fine, but my problem is that I want to add: distinct(case_id)

How to do that?

pauljohansson — Fri, 05 Apr 2013 12:37:01 GMT

Hi,

Have you looked at the AGGR function?

My thinking goes something like:

aggr( sum(round(Avg((end_date+end_time)-(start_date+start_time)),0.01)), case_id)

Paul

Tue, 09 Apr 2013 07:36:23 GMT

Hi,

Thanks for your help, but your suggestion doesn’t help. Do you have another proposal?

I haven’t used aggr before – I will look into that

Heine

Tue, 09 Apr 2013 07:44:17 GMT

Hi,

Thanks for your help, but your suggestion doesn’t help. Do you have another proposal?

I haven’t used aggr before – I will look into that

Heine

Tue, 09 Apr 2013 09:15:29 GMT

Hi,

Thanks for your help, but your suggestion doesn’t help. Do you have another proposal?

I haven’t used aggr before – I will look into that

Heine