topic Re: Create a new dimension in QlikView https://community.qlik.com/t5/QlikView/Create-a-new-dimension/m-p/514739#M481105 <HTML><HEAD></HEAD><BODY><P>If you always want to show Cancellation <EM>and</EM> Throwback then modify the expression to:</P><P></P><P>sum({$+&lt;Product={'Cancellation','Throwback'},Category=&gt;}Value)</P></BODY></HTML> Thu, 24 Oct 2013 12:58:15 GMT Gysbert_Wassenaar 2013-10-24T12:58:15Z Create a new dimension https://community.qlik.com/t5/QlikView/Create-a-new-dimension/m-p/514734#M481100 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>I have the follow information:</P><P></P><P>Month&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Category&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Product&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value</P><P>Feb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Emission&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $917</P><P>Feb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cancellation&nbsp;&nbsp;&nbsp;&nbsp; -$25</P><P>Feb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Emission&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $892</P><P>Feb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cancellation&nbsp;&nbsp;&nbsp;&nbsp; -$873</P><P></P><P>So, for business reasons, users need view in a sheet the information filtering Category 1 but in the pivot table Category 1 and Category 2 with Cancellation:</P><P></P><P>Month&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Product&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value</P><P>Feb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Emission&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $917</P><P>Feb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cancellation&nbsp;&nbsp;&nbsp;&nbsp; -$25</P><P><SPAN style="text-decoration: underline;">Feb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 - Emission&nbsp;&nbsp;&nbsp; -$873</SPAN></P><P></P><P>*Note that sheet has an action filtering Category = 1 when user enable sheet.</P><P></P><P>I hope be clear with explanation.</P><P></P><P>Regards,</P><P></P><P>- Javier</P></BODY></HTML> Wed, 23 Oct 2013 16:06:04 GMT https://community.qlik.com/t5/QlikView/Create-a-new-dimension/m-p/514734#M481100 javier_florian 2013-10-23T16:06:04Z Re: Create a new dimension https://community.qlik.com/t5/QlikView/Create-a-new-dimension/m-p/514735#M481101 <HTML><HEAD></HEAD><BODY><P>See attached example.</P></BODY></HTML> Wed, 23 Oct 2013 17:11:59 GMT https://community.qlik.com/t5/QlikView/Create-a-new-dimension/m-p/514735#M481101 Gysbert_Wassenaar 2013-10-23T17:11:59Z Re: Create a new dimension https://community.qlik.com/t5/QlikView/Create-a-new-dimension/m-p/514736#M481102 <HTML><HEAD></HEAD><BODY><P>It was so easy... Do you have documentation about work with that expression?</P><P>Regards,</P><P>- Javier Florián</P></BODY></HTML> Thu, 24 Oct 2013 12:41:07 GMT https://community.qlik.com/t5/QlikView/Create-a-new-dimension/m-p/514736#M481102 javier_florian 2013-10-24T12:41:07Z Re: Create a new dimension https://community.qlik.com/t5/QlikView/Create-a-new-dimension/m-p/514737#M481103 <HTML><HEAD></HEAD><BODY><P>See <A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/previewBody/1867-102-1-1858/QlikLearn-Set-Analysis-Presentation.pdf">here</A></P></BODY></HTML> Thu, 24 Oct 2013 12:49:38 GMT https://community.qlik.com/t5/QlikView/Create-a-new-dimension/m-p/514737#M481103 Gysbert_Wassenaar 2013-10-24T12:49:38Z Re: Create a new dimension https://community.qlik.com/t5/QlikView/Create-a-new-dimension/m-p/514738#M481104 <HTML><HEAD></HEAD><BODY><P>Hi Wassenaar,</P><P>I have an additional issue,... the requirement was modified: </P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 346px;"><TBODY><TR><TD height="20" width="117">Category</TD><TD width="106">Product Group</TD><TD width="123">Product</TD></TR><TR><TD align="right" height="20">1</TD><TD>Emission&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </TD><TD>Emission&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </TD></TR><TR><TD align="right" height="20">1</TD><TD>Cancellation&nbsp;&nbsp;&nbsp; </TD><TD>Cancellation&nbsp;&nbsp;&nbsp; </TD></TR><TR><TD align="right" height="20">1</TD><TD>Cancellation&nbsp;&nbsp;&nbsp; </TD><TD>Devolution</TD></TR><TR><TD align="right" height="20">2</TD><TD>Emission&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </TD><TD>Emission&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </TD></TR><TR><TD align="right" height="20">2</TD><TD>Emission&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </TD><TD class="xl65" width="123">Throwback</TD></TR><TR><TD align="right" height="20">2</TD><TD>Cancellation&nbsp;&nbsp;&nbsp; </TD><TD>Cancellation&nbsp;&nbsp;&nbsp; </TD></TR></TBODY></TABLE><P>Sheet filter applies when Category = 1, my graph shows values by Product Group, but I need add to chart values when Product = Throwback</P><P></P><P>Is possible with set expression?</P><P></P><P>Thanks in advanced.</P></BODY></HTML> Thu, 24 Oct 2013 12:55:34 GMT https://community.qlik.com/t5/QlikView/Create-a-new-dimension/m-p/514738#M481104 javier_florian 2013-10-24T12:55:34Z Re: Create a new dimension https://community.qlik.com/t5/QlikView/Create-a-new-dimension/m-p/514739#M481105 <HTML><HEAD></HEAD><BODY><P>If you always want to show Cancellation <EM>and</EM> Throwback then modify the expression to:</P><P></P><P>sum({$+&lt;Product={'Cancellation','Throwback'},Category=&gt;}Value)</P></BODY></HTML> Thu, 24 Oct 2013 12:58:15 GMT https://community.qlik.com/t5/QlikView/Create-a-new-dimension/m-p/514739#M481105 Gysbert_Wassenaar 2013-10-24T12:58:15Z Re: Create a new dimension https://community.qlik.com/t5/QlikView/Create-a-new-dimension/m-p/514740#M481106 <HTML><HEAD></HEAD><BODY><P>Great, regards Wassenaar!</P></BODY></HTML> Thu, 24 Oct 2013 14:19:23 GMT https://community.qlik.com/t5/QlikView/Create-a-new-dimension/m-p/514740#M481106 javier_florian 2013-10-24T14:19:23Z