topic Sales in QlikView https://community.qlik.com/t5/QlikView/Sales/m-p/737084#M1054586 <HTML><HEAD></HEAD><BODY><P>How to calculate the sales target of the year?</P></BODY></HTML> Fri, 31 Oct 2014 05:32:32 GMT gautik92 2014-10-31T05:32:32Z Sales https://community.qlik.com/t5/QlikView/Sales/m-p/737084#M1054586 <HTML><HEAD></HEAD><BODY><P>How to calculate the sales target of the year?</P></BODY></HTML> Fri, 31 Oct 2014 05:32:32 GMT https://community.qlik.com/t5/QlikView/Sales/m-p/737084#M1054586 gautik92 2014-10-31T05:32:32Z Re: Sales https://community.qlik.com/t5/QlikView/Sales/m-p/737085#M1054587 <HTML><HEAD></HEAD><BODY><P>Can you provide sample input and expected output</P></BODY></HTML> Fri, 31 Oct 2014 05:36:37 GMT https://community.qlik.com/t5/QlikView/Sales/m-p/737085#M1054587 anbu1984 2014-10-31T05:36:37Z Re: Sales https://community.qlik.com/t5/QlikView/Sales/m-p/737086#M1054588 <HTML><HEAD></HEAD><BODY><P>Sum(Sales Target) </P></BODY></HTML> Fri, 31 Oct 2014 05:37:25 GMT https://community.qlik.com/t5/QlikView/Sales/m-p/737086#M1054588 2014-10-31T05:37:25Z Re: Sales https://community.qlik.com/t5/QlikView/Sales/m-p/737087#M1054589 <HTML><HEAD></HEAD><BODY><P>Actually what do you want to ask,</P><P>Is sales target some field in data ???</P></BODY></HTML> Fri, 31 Oct 2014 05:39:46 GMT https://community.qlik.com/t5/QlikView/Sales/m-p/737087#M1054589 Anonymous 2014-10-31T05:39:46Z Re: Sales https://community.qlik.com/t5/QlikView/Sales/m-p/737088#M1054590 <HTML><HEAD></HEAD><BODY><P>For this you need the sales target value which most companies created at start of the companies business, and if you have that value then you can use simple aggregate function <SPAN style="font-size: 10pt; line-height: 1.5em;">SUM( [Sales Target] ) and dimension Year or Month.</SPAN></P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Fri, 31 Oct 2014 05:41:22 GMT https://community.qlik.com/t5/QlikView/Sales/m-p/737088#M1054590 its_anandrjs 2014-10-31T05:41:22Z