topic YTD, QTD & MTD Calculations in QlikView https://community.qlik.com/t5/QlikView/YTD-QTD-MTD-Calculations/m-p/174654#M43392 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am trying to build a report Daily Sales Report as below:</P><P>Example: I want to create a date prompt where user can select a Date depending on which the below mentioned report should change.</P><P>Here is the details of the Dimension &amp; Fact I am using for the report:</P><P>TABLE: REVENUE_FACT (Data Warehouse)</P><P>BRANCH,<BR />CUSTOMER,<BR />CUST NO.,<BR />SALES,<BR />INVOICE DATE,</P><P>TABLE: TIME_DIMENSION</P><P>CALENDAR_DATE,<BR />CALENDAR_MONTH,<BR />CALENDAR_QUARTER,<BR />CALENDAR_WEEK,<BR />CALENDAR_YEAR</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="642"><COL style="width: 48pt;" width="64" /><COL style="width: 44pt;" width="59" /><COL style="width: 88pt;" width="117" /><COL style="width: 49pt;" width="65" /><COL style="width: 61pt;" width="81" /><COL style="width: 31pt;" width="41" /><COL style="width: 52pt;" width="69" /><COL style="width: 54pt;" width="72" /><COL style="width: 56pt;" width="74" /><TBODY><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt; width: 48pt;" width="64">DIVISION</TD><TD style="width: 44pt;" width="59">BRANCH</TD><TD style="width: 88pt;" width="117">CUSTOMER NAME</TD><TD style="width: 49pt;" width="65">CUST. NO</TD><TD style="width: 61pt;" width="81">DAILY SALES</TD><TD style="width: 31pt;" width="41">TONS</TD><TD style="width: 52pt;" width="69">(YTD.SALES)</TD><TD style="width: 54pt;" width="72">(QTD.SALES)(</TD><TD style="width: 56pt;" width="74">MTD SALES)</TD></TR><TR height="20" style="height: 15pt;"><TD align="right" height="20" style="height: 15pt;">1<BR /></TD><TD>A</TD><TD>AB</TD><TD align="right">100</TD><TD align="right">1000</TD><TD align="right">2</TD><TD></TD><TD></TD><TD></TD></TR><TR height="20" style="height: 15pt;"><TD align="right" height="20" style="height: 15pt;">1<BR /></TD><TD>B</TD><TD>BC</TD><TD align="right">101</TD><TD align="right">2000</TD><TD align="right">5</TD><TD></TD><TD></TD><TD></TD></TR><TR height="20" style="height: 15pt;"><TD align="right" height="20" style="height: 15pt;">2<BR /></TD><TD>C</TD><TD>CD</TD><TD align="right">102</TD><TD align="right">3000</TD><TD align="right">7</TD><TD></TD><TD></TD><TD></TD></TR><TR height="20" style="height: 15pt;"><TD align="right" height="20" style="height: 15pt;">3<BR /></TD><TD>D</TD><TD>EF</TD><TD align="right">501</TD><TD align="right">4000</TD><TD align="right">9</TD><TD></TD><TD></TD><TD></TD></TR><TR height="20" style="height: 15pt;"><TD align="right" height="20" style="height: 15pt;">2<BR /></TD><TD>C</TD><TD>GH</TD><TD align="right">502</TD><TD align="right">5000</TD><TD align="right">10</TD><TD></TD><TD></TD><TD></TD></TR><TR height="20" style="height: 15pt;"><TD align="right" height="20" style="height: 15pt;">3<BR /></TD><TD>D</TD><TD>HI</TD><TD align="right">1000</TD><TD align="right">10000</TD><TD align="right">20</TD><TD></TD><TD></TD><TD></TD></TR><TR height="20" style="height: 15pt;"><TD align="right" height="20" style="height: 15pt;">4<BR /></TD><TD>E</TD><TD>JK</TD><TD align="right">1001</TD><TD align="right">11000</TD><TD align="right">13</TD><TD></TD><TD></TD><TD></TD></TR><TR height="20" style="height: 15pt;"><TD align="right" height="20" style="height: 15pt;">4<BR /></TD><TD>E</TD><TD>LM</TD><TD align="right">1002</TD><TD align="right">12000</TD><TD align="right">12</TD><TD></TD><TD></TD><TD></TD></TR><TR height="20" style="height: 15pt;"><TD align="right" height="20" style="height: 15pt;">5<BR /></TD><TD>G</TD><TD>OP</TD><TD align="right">5000</TD><TD align="right">3000</TD><TD align="right">11</TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 19 Jan 2011 01:39:54 GMT hkg_qlik 2011-01-19T01:39:54Z YTD, QTD & MTD Calculations https://community.qlik.com/t5/QlikView/YTD-QTD-MTD-Calculations/m-p/174654#M43392 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am trying to build a report Daily Sales Report as below:</P><P>Example: I want to create a date prompt where user can select a Date depending on which the below mentioned report should change.</P><P>Here is the details of the Dimension &amp; Fact I am using for the report:</P><P>TABLE: REVENUE_FACT (Data Warehouse)</P><P>BRANCH,<BR />CUSTOMER,<BR />CUST NO.,<BR />SALES,<BR />INVOICE DATE,</P><P>TABLE: TIME_DIMENSION</P><P>CALENDAR_DATE,<BR />CALENDAR_MONTH,<BR />CALENDAR_QUARTER,<BR />CALENDAR_WEEK,<BR />CALENDAR_YEAR</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="642"><COL style="width: 48pt;" width="64" /><COL style="width: 44pt;" width="59" /><COL style="width: 88pt;" width="117" /><COL style="width: 49pt;" width="65" /><COL style="width: 61pt;" width="81" /><COL style="width: 31pt;" width="41" /><COL style="width: 52pt;" width="69" /><COL style="width: 54pt;" width="72" /><COL style="width: 56pt;" width="74" /><TBODY><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt; width: 48pt;" width="64">DIVISION</TD><TD style="width: 44pt;" width="59">BRANCH</TD><TD style="width: 88pt;" width="117">CUSTOMER NAME</TD><TD style="width: 49pt;" width="65">CUST. NO</TD><TD style="width: 61pt;" width="81">DAILY SALES</TD><TD style="width: 31pt;" width="41">TONS</TD><TD style="width: 52pt;" width="69">(YTD.SALES)</TD><TD style="width: 54pt;" width="72">(QTD.SALES)(</TD><TD style="width: 56pt;" width="74">MTD SALES)</TD></TR><TR height="20" style="height: 15pt;"><TD align="right" height="20" style="height: 15pt;">1<BR /></TD><TD>A</TD><TD>AB</TD><TD align="right">100</TD><TD align="right">1000</TD><TD align="right">2</TD><TD></TD><TD></TD><TD></TD></TR><TR height="20" style="height: 15pt;"><TD align="right" height="20" style="height: 15pt;">1<BR /></TD><TD>B</TD><TD>BC</TD><TD align="right">101</TD><TD align="right">2000</TD><TD align="right">5</TD><TD></TD><TD></TD><TD></TD></TR><TR height="20" style="height: 15pt;"><TD align="right" height="20" style="height: 15pt;">2<BR /></TD><TD>C</TD><TD>CD</TD><TD align="right">102</TD><TD align="right">3000</TD><TD align="right">7</TD><TD></TD><TD></TD><TD></TD></TR><TR height="20" style="height: 15pt;"><TD align="right" height="20" style="height: 15pt;">3<BR /></TD><TD>D</TD><TD>EF</TD><TD align="right">501</TD><TD align="right">4000</TD><TD align="right">9</TD><TD></TD><TD></TD><TD></TD></TR><TR height="20" style="height: 15pt;"><TD align="right" height="20" style="height: 15pt;">2<BR /></TD><TD>C</TD><TD>GH</TD><TD align="right">502</TD><TD align="right">5000</TD><TD align="right">10</TD><TD></TD><TD></TD><TD></TD></TR><TR height="20" style="height: 15pt;"><TD align="right" height="20" style="height: 15pt;">3<BR /></TD><TD>D</TD><TD>HI</TD><TD align="right">1000</TD><TD align="right">10000</TD><TD align="right">20</TD><TD></TD><TD></TD><TD></TD></TR><TR height="20" style="height: 15pt;"><TD align="right" height="20" style="height: 15pt;">4<BR /></TD><TD>E</TD><TD>JK</TD><TD align="right">1001</TD><TD align="right">11000</TD><TD align="right">13</TD><TD></TD><TD></TD><TD></TD></TR><TR height="20" style="height: 15pt;"><TD align="right" height="20" style="height: 15pt;">4<BR /></TD><TD>E</TD><TD>LM</TD><TD align="right">1002</TD><TD align="right">12000</TD><TD align="right">12</TD><TD></TD><TD></TD><TD></TD></TR><TR height="20" style="height: 15pt;"><TD align="right" height="20" style="height: 15pt;">5<BR /></TD><TD>G</TD><TD>OP</TD><TD align="right">5000</TD><TD align="right">3000</TD><TD align="right">11</TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 19 Jan 2011 01:39:54 GMT https://community.qlik.com/t5/QlikView/YTD-QTD-MTD-Calculations/m-p/174654#M43392 hkg_qlik 2011-01-19T01:39:54Z YTD, QTD & MTD Calculations https://community.qlik.com/t5/QlikView/YTD-QTD-MTD-Calculations/m-p/174655#M43393 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>Give this a read: http://iqlik.wordpress.com/2010/11/27/the-magic-of-set-analysis-point-in-time-reporting/</P><P>Mike.</P></BODY></HTML> Wed, 19 Jan 2011 03:23:04 GMT https://community.qlik.com/t5/QlikView/YTD-QTD-MTD-Calculations/m-p/174655#M43393 mike_garcia 2011-01-19T03:23:04Z