topic YTD Sales in QlikView https://community.qlik.com/t5/QlikView/YTD-Sales/m-p/376386#M140323 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I would like to to find out the YTD Sales and show by Month</P><P>But I do not know what expression should I use.</P><P>As I have tried using different expression but failed.</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="193" style="width: 387px; height: 195px; border: #000000 1px solid;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Year</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Month</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Monthly Sales</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>YTD Sales</STRONG></SPAN></TH></TR><TR><TD>2012</TD><TD>01</TD><TD>200</TD><TD>200</TD></TR><TR><TD>2012</TD><TD>02</TD><TD>100</TD><TD>300</TD></TR><TR><TD>2012</TD><TD>03</TD><TD>300</TD><TD>600</TD></TR><TR><TD>2012</TD><TD>04</TD><TD>400</TD><TD>1000</TD></TR><TR><TD>2012</TD><TD>05</TD><TD>200</TD><TD>1200</TD></TR></TBODY></TABLE><P>I need help,</P><P>Thanks</P></BODY></HTML> Thu, 09 Aug 2012 03:19:35 GMT 2012-08-09T03:19:35Z YTD Sales https://community.qlik.com/t5/QlikView/YTD-Sales/m-p/376386#M140323 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I would like to to find out the YTD Sales and show by Month</P><P>But I do not know what expression should I use.</P><P>As I have tried using different expression but failed.</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="193" style="width: 387px; height: 195px; border: #000000 1px solid;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Year</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Month</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Monthly Sales</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>YTD Sales</STRONG></SPAN></TH></TR><TR><TD>2012</TD><TD>01</TD><TD>200</TD><TD>200</TD></TR><TR><TD>2012</TD><TD>02</TD><TD>100</TD><TD>300</TD></TR><TR><TD>2012</TD><TD>03</TD><TD>300</TD><TD>600</TD></TR><TR><TD>2012</TD><TD>04</TD><TD>400</TD><TD>1000</TD></TR><TR><TD>2012</TD><TD>05</TD><TD>200</TD><TD>1200</TD></TR></TBODY></TABLE><P>I need help,</P><P>Thanks</P></BODY></HTML> Thu, 09 Aug 2012 03:19:35 GMT https://community.qlik.com/t5/QlikView/YTD-Sales/m-p/376386#M140323 2012-08-09T03:19:35Z Re: YTD Sales https://community.qlik.com/t5/QlikView/YTD-Sales/m-p/376387#M140324 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>1. Load data</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_1344482862140371" jivemacro_uid="_1344482862140371"><P>[Data]:</P><P>LOAD * INLINE [</P><P>Years,&nbsp;&nbsp;&nbsp; Month,&nbsp;&nbsp;&nbsp; Monthly Sales</P><P>2012,&nbsp;&nbsp;&nbsp; 01,&nbsp;&nbsp;&nbsp; 200</P><P>2012,&nbsp;&nbsp;&nbsp; 02,&nbsp;&nbsp;&nbsp; 100</P><P>2012,&nbsp;&nbsp;&nbsp; 03,&nbsp;&nbsp;&nbsp; 300</P><P>2012,&nbsp;&nbsp;&nbsp; 04,&nbsp;&nbsp;&nbsp; 400</P><P>2012,&nbsp;&nbsp;&nbsp; 05,&nbsp;&nbsp;&nbsp; 200];</P></PRE><P>2. Create Straight Table</P><P>&nbsp;&nbsp;&nbsp;&nbsp; a. Years and Month as Dimension</P><P>&nbsp;&nbsp;&nbsp;&nbsp; b. Two Expression</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; i. SUM([Monthly Sales])</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ii. RangeSum(Above(Total Sum([Monthly Sales]),0,RowNo()))</P><P></P><P>See the sample attached file.</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Thu, 09 Aug 2012 03:30:46 GMT https://community.qlik.com/t5/QlikView/YTD-Sales/m-p/376387#M140324 Sokkorn 2012-08-09T03:30:46Z Re: YTD Sales https://community.qlik.com/t5/QlikView/YTD-Sales/m-p/376388#M140325 <HTML><HEAD></HEAD><BODY><P>Thanks so much:)</P></BODY></HTML> Thu, 09 Aug 2012 03:41:43 GMT https://community.qlik.com/t5/QlikView/YTD-Sales/m-p/376388#M140325 2012-08-09T03:41:43Z