topic Re: year calculation in QlikView https://community.qlik.com/t5/QlikView/year-calculation/m-p/920136#M318880 <HTML><HEAD></HEAD><BODY><P>please suggest some techniques on this to achieve the requirement </P></BODY></HTML> Wed, 12 Aug 2015 07:51:04 GMT ssriramin19 2015-08-12T07:51:04Z year calculation https://community.qlik.com/t5/QlikView/year-calculation/m-p/920131#M318875 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P> There are two fields actual sales and actual sales previous year .The date dimension will be always from jan 2015 to dec 2015. One year data will the date dimension.</P><P></P><P>with respect to actual sales&nbsp; it will be from jan 2015 to dec 2015..</P><P></P><P>But for actual sales previous year - need to compute actual sales for period from jan 2014 to dec 2014. So now I have computed individually both actual sales and actual sales last year. </P><P></P><P>But when displaying under jan 2015 it should be shown as actual sales for jan 2015 and actual sales previous sales for jan 2014. </P><P></P><P>Please find the image below.Under Jan 2015 it should display actual sales which has data for jan 2015 and also actual sales last year which has data for jan 2014. </P><P></P><P>How this year needs to be mapped meaning how the jan 2015 for actual sales and actual sales last year . </P><P></P><P>Please provide some inputs on this.</P><P></P><P><IMG alt="report_.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/95729_report_.jpg" style="height: 99px; width: 620px;" /></P></BODY></HTML> Wed, 12 Aug 2015 07:14:55 GMT https://community.qlik.com/t5/QlikView/year-calculation/m-p/920131#M318875 ssriramin19 2015-08-12T07:14:55Z Re: year calculation https://community.qlik.com/t5/QlikView/year-calculation/m-p/920132#M318876 <HTML><HEAD></HEAD><BODY><P>can any one suggest some technique on how to achieve the above scenario?</P></BODY></HTML> Wed, 12 Aug 2015 07:31:41 GMT https://community.qlik.com/t5/QlikView/year-calculation/m-p/920132#M318876 ssriramin19 2015-08-12T07:31:41Z Re: year calculation https://community.qlik.com/t5/QlikView/year-calculation/m-p/920133#M318877 <HTML><HEAD></HEAD><BODY><P>I you post your application qvw, or a sample qvw document containing representative data, you are more likely to get useful help with your problem.</P></BODY></HTML> Wed, 12 Aug 2015 07:34:23 GMT https://community.qlik.com/t5/QlikView/year-calculation/m-p/920133#M318877 jonathandienst 2015-08-12T07:34:23Z Re: year calculation https://community.qlik.com/t5/QlikView/year-calculation/m-p/920134#M318878 <HTML><HEAD></HEAD><BODY><P>the image attached above is the actual requirement for the report. </P></BODY></HTML> Wed, 12 Aug 2015 07:39:42 GMT https://community.qlik.com/t5/QlikView/year-calculation/m-p/920134#M318878 ssriramin19 2015-08-12T07:39:42Z Re: year calculation https://community.qlik.com/t5/QlikView/year-calculation/m-p/920135#M318879 <HTML><HEAD></HEAD><BODY><P>PNG &lt;&gt; QVW</P></BODY></HTML> Wed, 12 Aug 2015 07:50:02 GMT https://community.qlik.com/t5/QlikView/year-calculation/m-p/920135#M318879 jonathandienst 2015-08-12T07:50:02Z Re: year calculation https://community.qlik.com/t5/QlikView/year-calculation/m-p/920136#M318880 <HTML><HEAD></HEAD><BODY><P>please suggest some techniques on this to achieve the requirement </P></BODY></HTML> Wed, 12 Aug 2015 07:51:04 GMT https://community.qlik.com/t5/QlikView/year-calculation/m-p/920136#M318880 ssriramin19 2015-08-12T07:51:04Z Re: year calculation https://community.qlik.com/t5/QlikView/year-calculation/m-p/920137#M318881 <HTML><HEAD></HEAD><BODY><P>I can understand but how to achieve this scenario in qlikview ?</P></BODY></HTML> Wed, 12 Aug 2015 08:12:13 GMT https://community.qlik.com/t5/QlikView/year-calculation/m-p/920137#M318881 ssriramin19 2015-08-12T08:12:13Z