topic Re: avg caluclate in QlikView

avg caluclate

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I want to calculate the avg age in years [gauge chart]

my date field = opendate format [DD-MM-YYYY]

how to calculate this?

swuehl — Thu, 22 Mar 2018 07:29:40 GMT

Maybe just

= Avg( Age( Today(), opendate))

soniasweety — Thu, 22 Mar 2018 07:35:43 GMT

thanks but I need to calculate the today-Mydate [ as avg days]

avgdays is not required ?

Anonymous — Thu, 22 Mar 2018 07:42:25 GMT

Hi ,

Use below code

Date(Today(),'DD-MM-YYYY') - Date(Opendate,'DD-MM-YYYY') . Using this you will get the no'of days.

If you want to calculate in Years , Using the the IF condition you can able to retrive the year bucket.

Like IF(Date(Today(),'DD-MM-YYYY') - Date(Opendate,'DD-MM-YYYY')) <= 365 ,'< 1 Year',

IF(Date(Today(),'DD-MM-YYYY') - Date(Opendate,'DD-MM-YYYY')) > 365 and

IF(Date(Today(),'DD-MM-YYYY') - Date(Opendate,'DD-MM-YYYY')) <= 730 , '1 to 2 Years' )

Thanks,

Venkata Sreekanth

soniasweety — Thu, 22 Mar 2018 07:54:57 GMT

thanks its fine.

but I don't want to create if condition

I want to use as measure directly

can I use like below?

Now I got the no of days

so = avg(Numfday)/365 ?

rubenmarin — Thu, 22 Mar 2018 16:56:37 GMT

Hi sony, you can calculate the age in script with Age() function, and use an Avg() of this new field to calculate the average.

In front-end can be done with aggr()

Avg(Aggr(Age(Today(), opendate), FieldToIterateRecords) //IdEmployee/IdPatient...

MarcoWedel — Thu, 22 Mar 2018 21:09:54 GMT

please post some sample values and your expected result.