topic Re: Stumped By Average Expression? in QlikView

Stumped By Average Expression?

dmac1971 — Thu, 29 Jan 2015 12:37:53 GMT

OK I have the following Expression :

=Avg({< CURR_STATUS = {'CLOSED'} >} AGEDAYS )

To show the average age of closed tickets in a chart. AGEDAYS is Today() - Closedate, but the chart is showing the average as 54Hrs, and if background table extracted into Excel and the average hours checked the figure is correct, 7.8 Hrs.

What am I missing here?

Re: Stumped By Average Expression?

robert_mika — Thu, 29 Jan 2015 12:48:16 GMT

I have had situation where Data in Excel where wrong formatted giving different answers in Qlikview.

Could you attached your Excel file?

Re: Stumped By Average Expression?

rubenmarin — Thu, 29 Jan 2015 12:48:23 GMT

Hi Dermot, can you double-check Qv and Excel are doing the same operations.

The AGEDAYS field will load how much time has passed since the ticket was closed. Is Excel doing the same or it has his "AGEDAYS" already calculated?

Re: Stumped By Average Expression?

dmac1971 — Thu, 29 Jan 2015 13:05:21 GMT

Sorry if I extract the table out to Excel and then average the col its giving the right answer, QV is getting a wildly different answer!

Example data for Dec showing open and close dates, and number days taken attached.

Sample from Load Script to create close days :

Ceil(Today()-CREATEDDATE,1) As AGEDAYS

Thanks for help!!

Re: Stumped By Average Expression?

sunny_talwar — Thu, 29 Jan 2015 13:21:38 GMT

Do you want to find the difference between Today() and Closed Date or Closed Date and Open Date? In you Excel file you seem to be calculating the difference between Closed and Open.

Best,

Re: Stumped By Average Expression?

dmac1971 — Thu, 29 Jan 2015 13:24:47 GMT

Doh, as we call it here I've had a moment..... Now fixed. Thanks it was my own fault!!!!!