topic Sum by one dimension - exclude all other dimensions in QlikView https://community.qlik.com/t5/QlikView/Sum-by-one-dimension-exclude-all-other-dimensions/m-p/1334437#M411828 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>How to achieve "Amount Sum by P" in following table? There are dimensions from P to Z and I want Sum of Amount by P for each detail row.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 501px;"><TBODY><TR><TD class="xl64" height="20" style="text-align: center; vertical-align: middle; background-color: #c0c0c0;" width="64">P</TD><TD class="xl64" style="border-left: medium none; text-align: center; vertical-align: middle; background-color: #c0c0c0;" width="64">Q</TD><TD class="xl64" style="border-left: medium none; text-align: center; vertical-align: middle; background-color: #c0c0c0;" width="64">R</TD><TD class="xl64" style="border-left: medium none; text-align: center; vertical-align: middle; background-color: #c0c0c0;" width="64">S</TD><TD class="xl64" style="border-left: medium none; text-align: center; vertical-align: middle; background-color: #c0c0c0;" width="64">T</TD><TD class="xl64" style="border-left: medium none; text-align: center; vertical-align: middle; background-color: #c0c0c0;" width="64">Amount</TD><TD class="xl64" style="border-left: medium none; text-align: center; vertical-align: middle; background-color: #ffff00;" width="117">Amount Sum by P</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none; text-align: center; vertical-align: middle;">A1</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">B1</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">C1</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">D1</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">E1</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">10</TD><TD class="xl66" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle; background-color: #ffff00;">100</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none; text-align: center; vertical-align: middle;">A1</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">B2</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">C1</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">D2</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;"> </TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">20</TD><TD class="xl66" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle; background-color: #ffff00;">100</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none; text-align: center; vertical-align: middle;">A1</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;"> </TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">C2</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">D2</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">E3</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">30</TD><TD class="xl66" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle; background-color: #ffff00;">100</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none; text-align: center; vertical-align: middle;">A1</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">B3</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">C2</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;"> </TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;"> </TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">40</TD><TD class="xl66" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle; background-color: #ffff00;">100</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none; text-align: center; vertical-align: middle;">A2</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">B4</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">C3</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">D2</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;"> </TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">50</TD><TD class="xl66" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle; background-color: #ffff00;">180</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none; text-align: center; vertical-align: middle;">A2</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">B5</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">C4</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">D2</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">E3</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">60</TD><TD class="xl66" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle; background-color: #ffff00;">180</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none; text-align: center; vertical-align: middle;">A2</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">B5</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">C5</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;"> </TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;"> </TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">70</TD><TD class="xl66" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle; background-color: #ffff00;">180</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none; text-align: center; vertical-align: middle;">A3</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">B6</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">C5</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">D2</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;"> </TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">80</TD><TD class="xl66" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle; background-color: #ffff00;">80</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none; text-align: center; vertical-align: middle;">A4</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">B6</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">C5</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">D2</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">E4</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">90</TD><TD class="xl66" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle; background-color: #ffff00;">90</TD></TR></TBODY></TABLE><P></P><P>Thank You.</P></BODY></HTML> Wed, 19 Jul 2017 09:40:17 GMT 2017-07-19T09:40:17Z Sum by one dimension - exclude all other dimensions https://community.qlik.com/t5/QlikView/Sum-by-one-dimension-exclude-all-other-dimensions/m-p/1334437#M411828 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>How to achieve "Amount Sum by P" in following table? There are dimensions from P to Z and I want Sum of Amount by P for each detail row.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 501px;"><TBODY><TR><TD class="xl64" height="20" style="text-align: center; vertical-align: middle; background-color: #c0c0c0;" width="64">P</TD><TD class="xl64" style="border-left: medium none; text-align: center; vertical-align: middle; background-color: #c0c0c0;" width="64">Q</TD><TD class="xl64" style="border-left: medium none; text-align: center; vertical-align: middle; background-color: #c0c0c0;" width="64">R</TD><TD class="xl64" style="border-left: medium none; text-align: center; vertical-align: middle; background-color: #c0c0c0;" width="64">S</TD><TD class="xl64" style="border-left: medium none; text-align: center; vertical-align: middle; background-color: #c0c0c0;" width="64">T</TD><TD class="xl64" style="border-left: medium none; text-align: center; vertical-align: middle; background-color: #c0c0c0;" width="64">Amount</TD><TD class="xl64" style="border-left: medium none; text-align: center; vertical-align: middle; background-color: #ffff00;" width="117">Amount Sum by P</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none; text-align: center; vertical-align: middle;">A1</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">B1</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">C1</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">D1</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">E1</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">10</TD><TD class="xl66" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle; background-color: #ffff00;">100</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none; text-align: center; vertical-align: middle;">A1</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">B2</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">C1</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">D2</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;"> </TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">20</TD><TD class="xl66" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle; background-color: #ffff00;">100</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none; text-align: center; vertical-align: middle;">A1</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;"> </TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">C2</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">D2</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">E3</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">30</TD><TD class="xl66" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle; background-color: #ffff00;">100</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none; text-align: center; vertical-align: middle;">A1</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">B3</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">C2</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;"> </TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;"> </TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">40</TD><TD class="xl66" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle; background-color: #ffff00;">100</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none; text-align: center; vertical-align: middle;">A2</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">B4</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">C3</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">D2</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;"> </TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">50</TD><TD class="xl66" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle; background-color: #ffff00;">180</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none; text-align: center; vertical-align: middle;">A2</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">B5</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">C4</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">D2</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">E3</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">60</TD><TD class="xl66" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle; background-color: #ffff00;">180</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none; text-align: center; vertical-align: middle;">A2</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">B5</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">C5</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;"> </TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;"> </TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">70</TD><TD class="xl66" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle; background-color: #ffff00;">180</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none; text-align: center; vertical-align: middle;">A3</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">B6</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">C5</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">D2</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;"> </TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">80</TD><TD class="xl66" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle; background-color: #ffff00;">80</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none; text-align: center; vertical-align: middle;">A4</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">B6</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">C5</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">D2</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">E4</TD><TD class="xl65" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle;">90</TD><TD class="xl66" style="border-top: medium none; border-left: medium none; text-align: center; vertical-align: middle; background-color: #ffff00;">90</TD></TR></TBODY></TABLE><P></P><P>Thank You.</P></BODY></HTML> Wed, 19 Jul 2017 09:40:17 GMT https://community.qlik.com/t5/QlikView/Sum-by-one-dimension-exclude-all-other-dimensions/m-p/1334437#M411828 2017-07-19T09:40:17Z Re: Sum by one dimension - exclude all other dimensions https://community.qlik.com/t5/QlikView/Sum-by-one-dimension-exclude-all-other-dimensions/m-p/1334438#M411829 <HTML><HEAD></HEAD><BODY><P>This?</P><P></P><P><STRONG>Sum(TOTAL &lt;P&gt; Amount)</STRONG></P></BODY></HTML> Wed, 19 Jul 2017 15:44:39 GMT https://community.qlik.com/t5/QlikView/Sum-by-one-dimension-exclude-all-other-dimensions/m-p/1334438#M411829 Anil_Babu_Samineni 2017-07-19T15:44:39Z Re: Sum by one dimension - exclude all other dimensions https://community.qlik.com/t5/QlikView/Sum-by-one-dimension-exclude-all-other-dimensions/m-p/1334439#M411830 <HTML><HEAD></HEAD><BODY><P>Hi Anil,</P><P></P><P>Thanks for the answer.</P><P></P><P>This breaks the detail data and group the data. I want the data structure to remain in tact.</P><P></P><P>I guess there should be some alternate.</P><P></P><P>One option is to add the measure in Master data of P to avoid any SELECTION filters on other dimensions.</P><P></P><P>Kind Regards,</P><P>Jigar Sanghavi</P></BODY></HTML> Thu, 20 Jul 2017 07:32:33 GMT https://community.qlik.com/t5/QlikView/Sum-by-one-dimension-exclude-all-other-dimensions/m-p/1334439#M411830 2017-07-20T07:32:33Z Re: Sum by one dimension - exclude all other dimensions https://community.qlik.com/t5/QlikView/Sum-by-one-dimension-exclude-all-other-dimensions/m-p/1334440#M411831 <HTML><HEAD></HEAD><BODY><P>I am not sure, Why not?</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/170888_Capture.PNG" style="height: 146px; width: 620px;" /></P><P>OR</P><P><IMG alt="Capture.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/170889_Capture.PNG" style="height: 136px; width: 620px;" /></P></BODY></HTML> Thu, 20 Jul 2017 14:27:57 GMT https://community.qlik.com/t5/QlikView/Sum-by-one-dimension-exclude-all-other-dimensions/m-p/1334440#M411831 Anil_Babu_Samineni 2017-07-20T14:27:57Z