topic Re: restrict year & month in total function ? in QlikView https://community.qlik.com/t5/QlikView/restrict-year-month-in-total-function/m-p/573306#M213543 <HTML><HEAD></HEAD><BODY><P>please load sample data or apps.</P></BODY></HTML> Fri, 28 Mar 2014 07:15:32 GMT MK_QSL 2014-03-28T07:15:32Z restrict year & month in total function ? https://community.qlik.com/t5/QlikView/restrict-year-month-in-total-function/m-p/573305#M213542 <HTML><HEAD></HEAD><BODY><P>Expr:</P><P>=sum(RollingAvg)/sum(TOTAL{&lt;ABPM_DM_MarketProductGroups&gt;} RollingAvg)</P><P></P><P>If I am Selecting Year &amp; Month then I am getting accurate result..</P><P>But&nbsp; I want to see all the Months of Data at a time in the chart then I am getting Incorrect result..</P></BODY></HTML> Fri, 28 Mar 2014 06:56:23 GMT https://community.qlik.com/t5/QlikView/restrict-year-month-in-total-function/m-p/573305#M213542 2014-03-28T06:56:23Z Re: restrict year & month in total function ? https://community.qlik.com/t5/QlikView/restrict-year-month-in-total-function/m-p/573306#M213543 <HTML><HEAD></HEAD><BODY><P>please load sample data or apps.</P></BODY></HTML> Fri, 28 Mar 2014 07:15:32 GMT https://community.qlik.com/t5/QlikView/restrict-year-month-in-total-function/m-p/573306#M213543 MK_QSL 2014-03-28T07:15:32Z