topic conditional sum in pivot in QlikView https://community.qlik.com/t5/QlikView/conditional-sum-in-pivot/m-p/1318775#M619613 <HTML><HEAD></HEAD><BODY><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"><STRONG><BR />StudentName</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Score</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Age</STRONG></TH></TR><TR><TD style="padding: 2px;"><P>A</P></TD><TD style="padding: 2px;">55</TD><TD style="padding: 2px;">21</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">43</TD><TD style="padding: 2px;">19</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">55</TD><TD style="padding: 2px;">18</TD></TR><TR><TD>B</TD><TD>55</TD><TD><P>27</P></TD></TR><TR><TD>B</TD><TD>43</TD><TD><P>18</P></TD></TR><TR><TD>B</TD><TD>44</TD><TD>17</TD></TR><TR><TD>B</TD><TD>33</TD><TD>18</TD></TR><TR><TD>B</TD><TD>43</TD><TD>25</TD></TR></TBODY></TABLE><P></P><P></P><P>How can i create a pivot with subtotal of score only if Age is less then 20. Sub total will ignore the score for Age higher then 20.</P></BODY></HTML> Tue, 25 Apr 2017 19:52:25 GMT userid128223 2017-04-25T19:52:25Z conditional sum in pivot https://community.qlik.com/t5/QlikView/conditional-sum-in-pivot/m-p/1318775#M619613 <HTML><HEAD></HEAD><BODY><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"><STRONG><BR />StudentName</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Score</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Age</STRONG></TH></TR><TR><TD style="padding: 2px;"><P>A</P></TD><TD style="padding: 2px;">55</TD><TD style="padding: 2px;">21</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">43</TD><TD style="padding: 2px;">19</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">55</TD><TD style="padding: 2px;">18</TD></TR><TR><TD>B</TD><TD>55</TD><TD><P>27</P></TD></TR><TR><TD>B</TD><TD>43</TD><TD><P>18</P></TD></TR><TR><TD>B</TD><TD>44</TD><TD>17</TD></TR><TR><TD>B</TD><TD>33</TD><TD>18</TD></TR><TR><TD>B</TD><TD>43</TD><TD>25</TD></TR></TBODY></TABLE><P></P><P></P><P>How can i create a pivot with subtotal of score only if Age is less then 20. Sub total will ignore the score for Age higher then 20.</P></BODY></HTML> Tue, 25 Apr 2017 19:52:25 GMT https://community.qlik.com/t5/QlikView/conditional-sum-in-pivot/m-p/1318775#M619613 userid128223 2017-04-25T19:52:25Z Re: conditional sum in pivot https://community.qlik.com/t5/QlikView/conditional-sum-in-pivot/m-p/1318776#M619614 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P><STRONG>LOAD StudentName, </STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; Score, </STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; Age</STRONG></P><P><STRONG>FROM</STRONG></P><P><STRONG><SPAN>[</SPAN><A class="jive-link-message-small" data-containerid="2061" data-containertype="14" data-objectid="1256839" data-objecttype="2" href="https://community.qlik.com/message/1256839#1256839">https://community.qlik.com/message/1256839</A><SPAN>]</SPAN></STRONG></P><P><STRONG>(html, codepage is 1252, embedded labels, table is @1);</STRONG></P><P></P><P>Create Pivot Object and use Dim as StudentName</P><P>Expression is <STRONG>Sum({&lt;Age = {'&lt;20'}&gt;}Score)</STRONG></P><P></P><P>Go to Presentation tab and check the <STRONG>Partial Sum</STRONG> if you need</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/161235_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 26 Apr 2017 02:43:17 GMT https://community.qlik.com/t5/QlikView/conditional-sum-in-pivot/m-p/1318776#M619614 Anil_Babu_Samineni 2017-04-26T02:43:17Z