topic Re: How to explode dimension into an expression in QlikView https://community.qlik.com/t5/QlikView/How-to-explode-dimension-into-an-expression/m-p/753395#M268471 <HTML><HEAD></HEAD><BODY><P>Thank you!!!!</P></BODY></HTML> Thu, 05 Feb 2015 15:46:11 GMT 2015-02-05T15:46:11Z How to explode dimension into an expression https://community.qlik.com/t5/QlikView/How-to-explode-dimension-into-an-expression/m-p/753392#M268468 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I need to calculate the year's total customer into a month dimension.</P><P></P><P>This is the case</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Month</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Month's TOT</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Year's TOT</STRONG></TH></TR><TR><TD style="padding: 2px;">2014-09</TD><TD style="padding: 2px;">12</TD><TD style="padding: 2px;">66</TD></TR><TR><TD style="padding: 2px;">2014-10</TD><TD style="padding: 2px;">15</TD><TD style="padding: 2px;">66</TD></TR><TR><TD style="padding: 2px;">2014-11</TD><TD style="padding: 2px;">13</TD><TD style="padding: 2px;">66</TD></TR><TR><TD style="padding: 2px;">2014-12</TD><TD style="padding: 2px;">16</TD><TD style="padding: 2px;">66</TD></TR><TR><TD style="padding: 2px;">2015-01</TD><TD style="padding: 2px;">14</TD><TD style="padding: 2px;">31</TD></TR><TR><TD style="padding: 2px;">2015-02</TD><TD style="padding: 2px;">17</TD><TD style="padding: 2px;">31</TD></TR></TBODY></TABLE><P></P><P>How can write "Year's TOT" expression?</P><P></P><P>Is it possibile? How can solve this problem?</P><P></P><P>Regards,</P><P>Roberto</P></BODY></HTML> Thu, 05 Feb 2015 15:36:28 GMT https://community.qlik.com/t5/QlikView/How-to-explode-dimension-into-an-expression/m-p/753392#M268468 2015-02-05T15:36:28Z Re: How to explode dimension into an expression https://community.qlik.com/t5/QlikView/How-to-explode-dimension-into-an-expression/m-p/753393#M268469 <HTML><HEAD></HEAD><BODY><P>see attached</P></BODY></HTML> Thu, 05 Feb 2015 15:43:29 GMT https://community.qlik.com/t5/QlikView/How-to-explode-dimension-into-an-expression/m-p/753393#M268469 giakoum 2015-02-05T15:43:29Z Re: How to explode dimension into an expression https://community.qlik.com/t5/QlikView/How-to-explode-dimension-into-an-expression/m-p/753394#M268470 <HTML><HEAD></HEAD><BODY><P>Is this what you need?</P></BODY></HTML> Thu, 05 Feb 2015 15:43:53 GMT https://community.qlik.com/t5/QlikView/How-to-explode-dimension-into-an-expression/m-p/753394#M268470 alexandros17 2015-02-05T15:43:53Z Re: How to explode dimension into an expression https://community.qlik.com/t5/QlikView/How-to-explode-dimension-into-an-expression/m-p/753395#M268471 <HTML><HEAD></HEAD><BODY><P>Thank you!!!!</P></BODY></HTML> Thu, 05 Feb 2015 15:46:11 GMT https://community.qlik.com/t5/QlikView/How-to-explode-dimension-into-an-expression/m-p/753395#M268471 2015-02-05T15:46:11Z Re: How to explode dimension into an expression https://community.qlik.com/t5/QlikView/How-to-explode-dimension-into-an-expression/m-p/753396#M268472 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333330154419px;">Not properly, I want the sum for each year.</SPAN></P></BODY></HTML> Thu, 05 Feb 2015 15:47:58 GMT https://community.qlik.com/t5/QlikView/How-to-explode-dimension-into-an-expression/m-p/753396#M268472 2015-02-05T15:47:58Z Re: How to explode dimension into an expression https://community.qlik.com/t5/QlikView/How-to-explode-dimension-into-an-expression/m-p/753397#M268473 <HTML><HEAD></HEAD><BODY><P>Is it possible obtain the same result without displaying the Year dimension?</P></BODY></HTML> Thu, 05 Feb 2015 16:05:36 GMT https://community.qlik.com/t5/QlikView/How-to-explode-dimension-into-an-expression/m-p/753397#M268473 2015-02-05T16:05:36Z Re: How to explode dimension into an expression https://community.qlik.com/t5/QlikView/How-to-explode-dimension-into-an-expression/m-p/753398#M268474 <HTML><HEAD></HEAD><BODY><P>Here it is</P></BODY></HTML> Thu, 05 Feb 2015 16:15:51 GMT https://community.qlik.com/t5/QlikView/How-to-explode-dimension-into-an-expression/m-p/753398#M268474 alexandros17 2015-02-05T16:15:51Z Re: How to explode dimension into an expression https://community.qlik.com/t5/QlikView/How-to-explode-dimension-into-an-expression/m-p/753399#M268475 <HTML><HEAD></HEAD><BODY><P>Yes, now it's what I need.</P><P></P><P>Thank you!</P></BODY></HTML> Thu, 05 Feb 2015 16:17:35 GMT https://community.qlik.com/t5/QlikView/How-to-explode-dimension-into-an-expression/m-p/753399#M268475 2015-02-05T16:17:35Z Re: How to explode dimension into an expression https://community.qlik.com/t5/QlikView/How-to-explode-dimension-into-an-expression/m-p/753400#M268476 <HTML><HEAD></HEAD><BODY><P>Ok, now how can calculate total of the previous year and total of the previous n months?</P></BODY></HTML> Sat, 07 Feb 2015 07:36:38 GMT https://community.qlik.com/t5/QlikView/How-to-explode-dimension-into-an-expression/m-p/753400#M268476 2015-02-07T07:36:38Z