topic Need a variable in QlikView https://community.qlik.com/t5/QlikView/Need-a-variable/m-p/339175#M1178826 <HTML><HEAD></HEAD><BODY><P>Hi i have a requirement which needs the exact formula. I have attached the table chart, which exactly shows the formula. I need the formula for Average visits per user per month&nbsp; =</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 435px;"><TBODY><TR><TD class="xl65" height="17" width="435">&nbsp; (# of visits / Unique Users actually accessing QV) / (# of months) which is <SPAN style="font-size: 8pt;"><P>=((Count(Distinct(if(Year([MONTH_END_DT])=Year([MinDateVar]),[Timestamp],0))))/(Count(distinct(if(Year([MONTH_END_DT])=Year([MinDateVar]),[User_Pin_Key],0)))))/???????</P></SPAN></TD></TR></TBODY></TABLE><P>I want the formula for (# of months) which is the number of document accessed by a user in a month. It should be a variable. Since it may vary for different user accessing a document for different month.</P></BODY></HTML> Wed, 07 Mar 2012 07:55:09 GMT 2012-03-07T07:55:09Z Need a variable https://community.qlik.com/t5/QlikView/Need-a-variable/m-p/339175#M1178826 <HTML><HEAD></HEAD><BODY><P>Hi i have a requirement which needs the exact formula. I have attached the table chart, which exactly shows the formula. I need the formula for Average visits per user per month&nbsp; =</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 435px;"><TBODY><TR><TD class="xl65" height="17" width="435">&nbsp; (# of visits / Unique Users actually accessing QV) / (# of months) which is <SPAN style="font-size: 8pt;"><P>=((Count(Distinct(if(Year([MONTH_END_DT])=Year([MinDateVar]),[Timestamp],0))))/(Count(distinct(if(Year([MONTH_END_DT])=Year([MinDateVar]),[User_Pin_Key],0)))))/???????</P></SPAN></TD></TR></TBODY></TABLE><P>I want the formula for (# of months) which is the number of document accessed by a user in a month. It should be a variable. Since it may vary for different user accessing a document for different month.</P></BODY></HTML> Wed, 07 Mar 2012 07:55:09 GMT https://community.qlik.com/t5/QlikView/Need-a-variable/m-p/339175#M1178826 2012-03-07T07:55:09Z