https://community.qlik.com/t5/App-Development/AGGR-FORMULA/m-p/1781684#M60829 <DIV class="topic-subject-wrapper"><DIV class="lia-message-subject lia-component-message-view-widget-subject"><DIV class="MessageSubject"><DIV class="lia-message-subject">Virtual table question</DIV></DIV></DIV></DIV><DIV class="MessageInResponseTo lia-component-message-view-widget-in-response-to lia-component-in-response-to">&nbsp;</DIV><DIV class="lia-message-body lia-component-message-view-widget-body lia-component-body-signature-highlight-escalation lia-component-message-view-widget-body-signature-highlight-escalation"><DIV class="lia-message-body-content"><P>Hi Community!</P><P>I am working with a qliksense app that has the information as follows in one of my tables:</P><TABLE><TBODY><TR><TD>TABLE 1</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>PERSON 1&nbsp;</TD><TD>PERSON 2</TD><TD>PRODUCTS</TD><TD>OBJECTIVE</TD><TD>MAX OBJECTIVE</TD></TR><TR><TD>JUAN</TD><TD>1</TD><TD>PRODUCT 1</TD><TD>12</TD><TD>12</TD></TR><TR><TD>JUAN</TD><TD>1</TD><TD>PRODUCT 2</TD><TD>2</TD><TD><FONT color="#00CCFF">12</FONT></TD></TR><TR><TD>JUAN</TD><TD>2</TD><TD>PRODUCT 3</TD><TD>34</TD><TD>34</TD></TR><TR><TD>JUAN</TD><TD>2</TD><TD>PRODUCT 2</TD><TD>3</TD><TD><FONT color="#00CCFF">34</FONT></TD></TR><TR><TD>JUAN</TD><TD>3</TD><TD>PRODUCT 1</TD><TD>12</TD><TD><FONT color="#00CCFF">33</FONT></TD></TR><TR><TD>JUAN</TD><TD>3</TD><TD>PRODUCT 3</TD><TD>33</TD><TD>33</TD></TR><TR><TD>JUAN</TD><TD>4</TD><TD>PRODUCT 2</TD><TD>32</TD><TD><FONT color="#00CCFF">64</FONT></TD></TR><TR><TD>JUAN</TD><TD>4</TD><TD>PRODUCT 2</TD><TD>64</TD><TD>64</TD></TR><TR><TD>JUAN</TD><TD>4</TD><TD>PRODUCT 3</TD><TD>64</TD><TD>64</TD></TR><TR><TD>JUAN</TD><TD>5</TD><TD>PRODUCT 1</TD><TD>2</TD><TD><FONT color="#00CCFF">54</FONT></TD></TR><TR><TD>JUAN</TD><TD>5</TD><TD>PRODUCT 3</TD><TD>54</TD><TD>54</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I need to create a new table with person 1 as dimension and need to sumarize the max objective of each Person 2 and show it as a total for Juan.</P><P>The result should be summarizing each light blue result and in this case is 197</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>PERSON 1</TD><TD>RESULT</TD></TR><TR><TD>JUAN</TD><TD>197</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I tried with AGGR but without success..&nbsp;</P><P>&nbsp;</P><P>aggr(SUM(Max OBJECTIVE),PERSON 1,PERSON 2)</P><P>Will really appreciate your help to sort this out.</P><P>&nbsp;</P><P>Thanks!!!</P><P>&nbsp;</P><P>Sofía</P></DIV></DIV> Wed, 10 Feb 2021 15:04:25 GMT sguerra2 2021-02-10T15:04:25Z https://community.qlik.com/t5/App-Development/AGGR-FORMULA/m-p/1781684#M60829 <DIV class="topic-subject-wrapper"><DIV class="lia-message-subject lia-component-message-view-widget-subject"><DIV class="MessageSubject"><DIV class="lia-message-subject">Virtual table question</DIV></DIV></DIV></DIV><DIV class="MessageInResponseTo lia-component-message-view-widget-in-response-to lia-component-in-response-to">&nbsp;</DIV><DIV class="lia-message-body lia-component-message-view-widget-body lia-component-body-signature-highlight-escalation lia-component-message-view-widget-body-signature-highlight-escalation"><DIV class="lia-message-body-content"><P>Hi Community!</P><P>I am working with a qliksense app that has the information as follows in one of my tables:</P><TABLE><TBODY><TR><TD>TABLE 1</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>PERSON 1&nbsp;</TD><TD>PERSON 2</TD><TD>PRODUCTS</TD><TD>OBJECTIVE</TD><TD>MAX OBJECTIVE</TD></TR><TR><TD>JUAN</TD><TD>1</TD><TD>PRODUCT 1</TD><TD>12</TD><TD>12</TD></TR><TR><TD>JUAN</TD><TD>1</TD><TD>PRODUCT 2</TD><TD>2</TD><TD><FONT color="#00CCFF">12</FONT></TD></TR><TR><TD>JUAN</TD><TD>2</TD><TD>PRODUCT 3</TD><TD>34</TD><TD>34</TD></TR><TR><TD>JUAN</TD><TD>2</TD><TD>PRODUCT 2</TD><TD>3</TD><TD><FONT color="#00CCFF">34</FONT></TD></TR><TR><TD>JUAN</TD><TD>3</TD><TD>PRODUCT 1</TD><TD>12</TD><TD><FONT color="#00CCFF">33</FONT></TD></TR><TR><TD>JUAN</TD><TD>3</TD><TD>PRODUCT 3</TD><TD>33</TD><TD>33</TD></TR><TR><TD>JUAN</TD><TD>4</TD><TD>PRODUCT 2</TD><TD>32</TD><TD><FONT color="#00CCFF">64</FONT></TD></TR><TR><TD>JUAN</TD><TD>4</TD><TD>PRODUCT 2</TD><TD>64</TD><TD>64</TD></TR><TR><TD>JUAN</TD><TD>4</TD><TD>PRODUCT 3</TD><TD>64</TD><TD>64</TD></TR><TR><TD>JUAN</TD><TD>5</TD><TD>PRODUCT 1</TD><TD>2</TD><TD><FONT color="#00CCFF">54</FONT></TD></TR><TR><TD>JUAN</TD><TD>5</TD><TD>PRODUCT 3</TD><TD>54</TD><TD>54</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I need to create a new table with person 1 as dimension and need to sumarize the max objective of each Person 2 and show it as a total for Juan.</P><P>The result should be summarizing each light blue result and in this case is 197</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>PERSON 1</TD><TD>RESULT</TD></TR><TR><TD>JUAN</TD><TD>197</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I tried with AGGR but without success..&nbsp;</P><P>&nbsp;</P><P>aggr(SUM(Max OBJECTIVE),PERSON 1,PERSON 2)</P><P>Will really appreciate your help to sort this out.</P><P>&nbsp;</P><P>Thanks!!!</P><P>&nbsp;</P><P>Sofía</P></DIV></DIV> Wed, 10 Feb 2021 15:04:25 GMT https://community.qlik.com/t5/App-Development/AGGR-FORMULA/m-p/1781684#M60829 sguerra2 2021-02-10T15:04:25Z https://community.qlik.com/t5/App-Development/AGGR-FORMULA/m-p/1781700#M60831 <P>Try this</P><LI-CODE lang="php">Aggr( SUM( Aggr( Max(OBJECTIVE) ,[PERSON 1],[PERSON 2] ) ) ,[PERSON 1] )</LI-CODE> Wed, 10 Feb 2021 15:39:35 GMT https://community.qlik.com/t5/App-Development/AGGR-FORMULA/m-p/1781700#M60831 PradeepK 2021-02-10T15:39:35Z https://community.qlik.com/t5/App-Development/AGGR-FORMULA/m-p/1781723#M60834 <P>Thanks&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/54791">@PradeepK</a>&nbsp;! it is working <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>&nbsp;</P><P>Best Regards.</P><P>&nbsp;</P><P>Sofía</P> Wed, 10 Feb 2021 16:31:52 GMT https://community.qlik.com/t5/App-Development/AGGR-FORMULA/m-p/1781723#M60834 sguerra2 2021-02-10T16:31:52Z