topic Re: Month Calculated Dimension in QlikView https://community.qlik.com/t5/QlikView/Month-Calculated-Dimension/m-p/505783#M483616 <HTML><HEAD></HEAD><BODY><P>It Works! </P><P></P><P>Thank You Gysbert!</P></BODY></HTML> Tue, 25 Jun 2013 11:20:33 GMT 2013-06-25T11:20:33Z Month Calculated Dimension https://community.qlik.com/t5/QlikView/Month-Calculated-Dimension/m-p/505781#M483614 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a table similar to this:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Site</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>Year</STRONG></SPAN></TH><TD> Units</TD></TR><TR><TD>East Linton</TD><TD>Jan</TD><TD>13</TD><TD>0</TD></TR><TR><TD>East Linton</TD><TD>Feb</TD><TD>13</TD><TD>0</TD></TR><TR><TD>East Linton</TD><TD>Mar</TD><TD>13</TD><TD>17</TD></TR><TR><TD>East Linton</TD><TD>Apr</TD><TD><P>13</P></TD><TD>15</TD></TR></TBODY></TABLE><P></P><P></P><P>What I need to calculate is the Total No of Units - 32 and the&nbsp; Month where the the first units were sold - Mar 13. I need to create a chart that will look as follows:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Site</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Month of Purchase</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Units Sold</STRONG></SPAN></TH></TR><TR><TD>East Linton</TD><TD>Mar 13</TD><TD>32</TD></TR></TBODY></TABLE><P></P><P>I have Site as a Dimesion. The calculation for units sold is, this works fine:</P><P></P><P>sum<SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">DISTINCT</SPAN><SPAN style="font-size: 8pt;"> </SPAN><STRONG><EM style=": ; color: #808080; font-size: 8pt;">$(vUnitsSold)</EM></STRONG><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">Site</SPAN><SPAN style="font-size: 8pt;">)) </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">However I am sturggling to work out the Calculated Dimension to give me the Month where Units &lt;&gt; 0 and Month = Min(Month) where a value exists?</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Any help appreciated.</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Thanks,</SPAN></P><P><SPAN style="font-size: 10pt;">Nikki </SPAN></P></BODY></HTML> Tue, 25 Jun 2013 09:52:19 GMT https://community.qlik.com/t5/QlikView/Month-Calculated-Dimension/m-p/505781#M483614 2013-06-25T09:52:19Z Re: Month Calculated Dimension https://community.qlik.com/t5/QlikView/Month-Calculated-Dimension/m-p/505782#M483615 <HTML><HEAD></HEAD><BODY><P>See attached example.</P></BODY></HTML> Tue, 25 Jun 2013 10:01:53 GMT https://community.qlik.com/t5/QlikView/Month-Calculated-Dimension/m-p/505782#M483615 Gysbert_Wassenaar 2013-06-25T10:01:53Z Re: Month Calculated Dimension https://community.qlik.com/t5/QlikView/Month-Calculated-Dimension/m-p/505783#M483616 <HTML><HEAD></HEAD><BODY><P>It Works! </P><P></P><P>Thank You Gysbert!</P></BODY></HTML> Tue, 25 Jun 2013 11:20:33 GMT https://community.qlik.com/t5/QlikView/Month-Calculated-Dimension/m-p/505783#M483616 2013-06-25T11:20:33Z