topic Re: How to find average documents used in a month in QlikView

How to find average documents used in a month

Fri, 02 Mar 2012 06:12:14 GMT

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

jagan — Fri, 02 Mar 2012 06:15:15 GMT

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 — Fri, 02 Mar 2012 06:32:45 GMT

Hi,

Try with this expression

Chart:Pivot

Dimension: Month,User

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

Hope it helps

Celambarasan

Fri, 02 Mar 2012 06:56:21 GMT

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

CELAMBARASAN — Fri, 02 Mar 2012 07:00:12 GMT

Hi,

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

Celambarasan

jagan — Fri, 02 Mar 2012 07:02:55 GMT

Hi,

Then use this expression

=Count(Document_name)/Count(DISTINCT Month)

Regards,

Jagan.

sridhar240784 — Fri, 02 Mar 2012 07:47:22 GMT

Hi,

Check whether the attached application help you.

-Sridhar