topic Make an avg on 2 dates with a distinct variable in QlikView https://community.qlik.com/t5/QlikView/Make-an-avg-on-2-dates-with-a-distinct-variable/m-p/422633#M1153314 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>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:</P><P></P><P>round(Avg((end_date+end_time)-(start_date+start_time)),0.01) </P><P></P><P>It works fine, but my problem is that I want to add: distinct(case_id)</P><P></P><P>who to do that?</P></BODY></HTML> Thu, 04 Apr 2013 13:44:52 GMT 2013-04-04T13:44:52Z Make an avg on 2 dates with a distinct variable https://community.qlik.com/t5/QlikView/Make-an-avg-on-2-dates-with-a-distinct-variable/m-p/422633#M1153314 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>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:</P><P></P><P>round(Avg((end_date+end_time)-(start_date+start_time)),0.01) </P><P></P><P>It works fine, but my problem is that I want to add: distinct(case_id)</P><P></P><P>who to do that?</P></BODY></HTML> Thu, 04 Apr 2013 13:44:52 GMT https://community.qlik.com/t5/QlikView/Make-an-avg-on-2-dates-with-a-distinct-variable/m-p/422633#M1153314 2013-04-04T13:44:52Z