topic Re: Many to One Calculated Dimension in QlikView https://community.qlik.com/t5/QlikView/Many-to-One-Calculated-Dimension/m-p/1293000#M618942 <HTML><HEAD></HEAD><BODY><P>May be use ValueList</P><P></P><P>Dimension</P><P><STRONG>Pick(ValueList(1, 2), 'All', Company)</STRONG></P><P></P><P>Expression</P><P><STRONG>Sum(Sales)</STRONG></P></BODY></HTML> Tue, 28 Mar 2017 15:11:24 GMT sunny_talwar 2017-03-28T15:11:24Z Many to One Calculated Dimension https://community.qlik.com/t5/QlikView/Many-to-One-Calculated-Dimension/m-p/1292999#M618941 <HTML><HEAD></HEAD><BODY><P>Is there a way to create a many to one relationship dimension with an expression?</P><P></P><P>What I am trying to get is something like this:</P><P></P><P>Dimension:</P><P>Company,</P><P>A,</P><P>B</P><P>C.</P><P></P><P></P><P>Chart:</P><P>Company&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sales</P><P>All&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 350</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50</P><P></P><P></P><P>If I can create this then I believe there is a way to have users do custom groupings in ad hoc reports. They like to group a sub set of values and compare against the total and regular values. The only solutions I could find involved macros or grouping the dimension into groups keeping the one to one relationship, both of which would not work for my need.</P></BODY></HTML> Tue, 28 Mar 2017 15:07:46 GMT https://community.qlik.com/t5/QlikView/Many-to-One-Calculated-Dimension/m-p/1292999#M618941 2017-03-28T15:07:46Z Re: Many to One Calculated Dimension https://community.qlik.com/t5/QlikView/Many-to-One-Calculated-Dimension/m-p/1293000#M618942 <HTML><HEAD></HEAD><BODY><P>May be use ValueList</P><P></P><P>Dimension</P><P><STRONG>Pick(ValueList(1, 2), 'All', Company)</STRONG></P><P></P><P>Expression</P><P><STRONG>Sum(Sales)</STRONG></P></BODY></HTML> Tue, 28 Mar 2017 15:11:24 GMT https://community.qlik.com/t5/QlikView/Many-to-One-Calculated-Dimension/m-p/1293000#M618942 sunny_talwar 2017-03-28T15:11:24Z Re: Many to One Calculated Dimension https://community.qlik.com/t5/QlikView/Many-to-One-Calculated-Dimension/m-p/1293001#M618943 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>for the 'All' dimension values requirement you probably<SPAN style="font-size: 13.3333px;"> </SPAN>could use something like a dimensional link table:</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/download/3451-6-46406/Generic Keys.pdf" title="https://community.qlik.com/servlet/JiveServlet/download/3451-6-46406/Generic%20Keys.pdf">https://community.qlik.com/servlet/JiveServlet/download/3451-6-46406/Generic%20Keys.pdf</A></P><P>(page 5)</P><P><A href="https://community.qlik.com/docs/DOC-3451">Generic keys</A></P><P><A href="https://community.qlik.com/qlik-blogpost/2819">Fact Table with Mixed Granularity</A></P><P></P><P>the dynamic grouping requirement on the other hand might be implemented like this (using macros though...):</P><P><A href="https://community.qlik.com/docs/DOC-6076">grouping dimension values</A></P><P></P><P></P><P>hope this helps nevertheless</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Wed, 29 Mar 2017 21:36:40 GMT https://community.qlik.com/t5/QlikView/Many-to-One-Calculated-Dimension/m-p/1293001#M618943 MarcoWedel 2017-03-29T21:36:40Z