Make an avg on 2 dates with a distinct variable

[#1]

Hi

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]

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)

br

Paul

[#3]

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

[#4]

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

[#5]

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