Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
soniasweety
Valued Contributor III

avg days

Hi all,

I want to calculate the avg days

how can I do this?

Thanks.

Tags (2)
3 Replies
kanchandendge
New Contributor II

Re: avg days

hi,

You can try this expression :

=Avg(DATE)  to calculate the Average

=date(Avg(DATE))

average of the DATE field and convert it into date.

Not applicable

Re: avg days

Hi,

Do you need avg days per month? or avg days per year

?

rahulpawarb
Valued Contributor III

Re: avg days

Hello Sony,

Trust that you are doing great!

By reviewing the attached qvf file and data file I am unable to get the exact requirement of Avg Days. Could you please elaborate more on this? This will facilitate me to provide you expected response.

Regards!
Rahul