topic Create data MTD AND YTD side by side in QlikView https://community.qlik.com/t5/QlikView/Create-data-MTD-AND-YTD-side-by-side/m-p/1265404#M850405 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hi,</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I following data get via select statement.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Key_Account Manger</P><P style="font-size: 13.3333px;">Customer_Name</P><P style="font-size: 13.3333px;">Product_description</P><P style="font-size: 13.3333px;">Invoice_date</P><P style="font-size: 13.3333px;">Quantity</P><P style="font-size: 13.3333px;">SalesValue</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Our Financial Year Starts from APR to MAR.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Data I need to show will be like.</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MTD MTD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; YTD&nbsp;&nbsp; YTD</P><P style="font-size: 13.3333px;">Key_Account_manager&nbsp; Customer_Name&nbsp;&nbsp; Product_description&nbsp;&nbsp; Qty&nbsp; SalesValue&nbsp;&nbsp;&nbsp;&nbsp; QTY&nbsp;&nbsp; SalesValue</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I would like the user to pass the parameter [Month Date]&nbsp; the system should work out the start from date Apr</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I am very new to Qlikview,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Create data MTD AND YTD side by side https://community.qlik.com/t5/QlikView/Create-data-MTD-AND-YTD-side-by-side/m-p/1265404#M850405 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hi,</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I following data get via select statement.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Key_Account Manger</P><P style="font-size: 13.3333px;">Customer_Name</P><P style="font-size: 13.3333px;">Product_description</P><P style="font-size: 13.3333px;">Invoice_date</P><P style="font-size: 13.3333px;">Quantity</P><P style="font-size: 13.3333px;">SalesValue</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Our Financial Year Starts from APR to MAR.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Data I need to show will be like.</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MTD MTD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; YTD&nbsp;&nbsp; YTD</P><P style="font-size: 13.3333px;">Key_Account_manager&nbsp; Customer_Name&nbsp;&nbsp; Product_description&nbsp;&nbsp; Qty&nbsp; SalesValue&nbsp;&nbsp;&nbsp;&nbsp; QTY&nbsp;&nbsp; SalesValue</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I would like the user to pass the parameter [Month Date]&nbsp; the system should work out the start from date Apr</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I am very new to Qlikview,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Create-data-MTD-AND-YTD-side-by-side/m-p/1265404#M850405 2020-11-25T16:16:04Z Re: Create data MTD AND YTD side by side https://community.qlik.com/t5/QlikView/Create-data-MTD-AND-YTD-side-by-side/m-p/1265405#M850406 <HTML><HEAD></HEAD><BODY><P>a very elegant solution here:</P><P></P><P><A href="https://community.qlik.com/thread/74204">The Magic of Set Analysis - Point in Time Reporting</A></P></BODY></HTML> Fri, 10 Mar 2017 05:22:44 GMT https://community.qlik.com/t5/QlikView/Create-data-MTD-AND-YTD-side-by-side/m-p/1265405#M850406 PaulVanSiclen 2017-03-10T05:22:44Z