Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to find average documents used in a month

Hi i need a formula to find out the below scenario,

Average Number of documents Visited by a user per month. Where field to be used are.User_name ,   Document_name ,  Month

6 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

Use Month as dimension in chart, and use the below expression

=Count(Document_name)/Count(Distinct User_name)

Hope this helps you.

Regards,

Jagan.

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Try with this expression

     Chart:Pivot

     Dimension: Month,User

     Expression: =Count(Distinct Document_name)/Count(TOTAL Distinct Month)

Hope it helps

Celambarasan

Not applicable
Author

i need to havit everything in a expression. I should use it as a formula

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Total number of documents/total number of months and it should be calculated individually for each user.

Celambarasan

jagan
Luminary Alumni
Luminary Alumni

Hi,

Then use this expression

=Count(Document_name)/Count(DISTINCT Month)

Regards,

Jagan.

sridhar240784
Creator III
Creator III

Hi,

Check whether the attached application help you.

-Sridhar