topic Conditional Calculation in a chart in QlikView https://community.qlik.com/t5/QlikView/Conditional-Calculation-in-a-chart/m-p/1770413#M717047 <P>Hi, everybody</P><P>Merry&nbsp; Christmas</P><P>I have following table and going to have a Bar Chart</P><P>X-Axe be "Ord_Mah"</P><P>Y-Axe be (the sum of&nbsp; Ord_Qty for the Max of Date_S.</P><P>(Please check the Pivot table at the end of this post.</P><TABLE><TBODY><TR><TD>Ord_Mah</TD><TD>Date_S</TD><TD>Tech_No</TD><TD>Ord_QTY</TD></TR><TR><TD>Azar</TD><TD>13990927</TD><TD>YGVQ</TD><TD>28</TD></TR><TR><TD>Azar</TD><TD>13990927</TD><TD>1101</TD><TD>16</TD></TR><TR><TD>Azar</TD><TD>13990927</TD><TD>1001</TD><TD>50</TD></TR><TR><TD>Azar</TD><TD>13990929</TD><TD>YGVQ</TD><TD>30</TD></TR><TR><TD>Azar</TD><TD>13990929</TD><TD>1101</TD><TD>20</TD></TR><TR><TD>Azar</TD><TD>13990929</TD><TD>1001</TD><TD>60</TD></TR><TR><TD>Azar</TD><TD>13990930</TD><TD>YGVQ</TD><TD>32</TD></TR><TR><TD>Azar</TD><TD>13990930</TD><TD>1101</TD><TD>24</TD></TR><TR><TD>Azar</TD><TD>13990930</TD><TD>1001</TD><TD>70</TD></TR><TR><TD>Azar</TD><TD>13991001</TD><TD>YGVQ</TD><TD>34</TD></TR><TR><TD>Azar</TD><TD>13991001</TD><TD>1101</TD><TD>30</TD></TR><TR><TD>Azar</TD><TD>13991001</TD><TD>1001</TD><TD>80</TD></TR><TR><TD>Azar</TD><TD>13991002</TD><TD>YGVQ</TD><TD>36</TD></TR><TR><TD>Azar</TD><TD>13991002</TD><TD>1101</TD><TD>34</TD></TR><TR><TD>Azar</TD><TD>13991002</TD><TD>1001</TD><TD>90</TD></TR><TR><TD>DAY</TD><TD>13991003</TD><TD>YGVQ</TD><TD>35</TD></TR><TR><TD>DAY</TD><TD>13991003</TD><TD>1101</TD><TD>60</TD></TR><TR><TD>DAY</TD><TD>13991004</TD><TD>YGVQ</TD><TD>38</TD></TR><TR><TD>DAY</TD><TD>13991004</TD><TD>1101</TD><TD>70</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE><TBODY><TR><TD>Date_S</TD><TD>Azar</TD><TD>DAY</TD></TR><TR><TD>13990927</TD><TD>94</TD><TD>&nbsp;</TD></TR><TR><TD>13990929</TD><TD>110</TD><TD>&nbsp;</TD></TR><TR><TD>13990930</TD><TD>126</TD><TD>&nbsp;</TD></TR><TR><TD>13991001</TD><TD>144</TD><TD>&nbsp;</TD></TR><TR><TD>13991002</TD><TD><FONT face="impact,chicago"><STRONG>160</STRONG></FONT></TD><TD>&nbsp;</TD></TR><TR><TD>13991003</TD><TD>&nbsp;</TD><TD>94</TD></TR><TR><TD>13991004</TD><TD>&nbsp;</TD><TD><FONT face="impact,chicago"><STRONG>108</STRONG></FONT></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Best wishes.</P><P>&nbsp;</P> Thu, 24 Dec 2020 09:58:45 GMT Hamid_Reza_Rashidi 2020-12-24T09:58:45Z Conditional Calculation in a chart https://community.qlik.com/t5/QlikView/Conditional-Calculation-in-a-chart/m-p/1770413#M717047 <P>Hi, everybody</P><P>Merry&nbsp; Christmas</P><P>I have following table and going to have a Bar Chart</P><P>X-Axe be "Ord_Mah"</P><P>Y-Axe be (the sum of&nbsp; Ord_Qty for the Max of Date_S.</P><P>(Please check the Pivot table at the end of this post.</P><TABLE><TBODY><TR><TD>Ord_Mah</TD><TD>Date_S</TD><TD>Tech_No</TD><TD>Ord_QTY</TD></TR><TR><TD>Azar</TD><TD>13990927</TD><TD>YGVQ</TD><TD>28</TD></TR><TR><TD>Azar</TD><TD>13990927</TD><TD>1101</TD><TD>16</TD></TR><TR><TD>Azar</TD><TD>13990927</TD><TD>1001</TD><TD>50</TD></TR><TR><TD>Azar</TD><TD>13990929</TD><TD>YGVQ</TD><TD>30</TD></TR><TR><TD>Azar</TD><TD>13990929</TD><TD>1101</TD><TD>20</TD></TR><TR><TD>Azar</TD><TD>13990929</TD><TD>1001</TD><TD>60</TD></TR><TR><TD>Azar</TD><TD>13990930</TD><TD>YGVQ</TD><TD>32</TD></TR><TR><TD>Azar</TD><TD>13990930</TD><TD>1101</TD><TD>24</TD></TR><TR><TD>Azar</TD><TD>13990930</TD><TD>1001</TD><TD>70</TD></TR><TR><TD>Azar</TD><TD>13991001</TD><TD>YGVQ</TD><TD>34</TD></TR><TR><TD>Azar</TD><TD>13991001</TD><TD>1101</TD><TD>30</TD></TR><TR><TD>Azar</TD><TD>13991001</TD><TD>1001</TD><TD>80</TD></TR><TR><TD>Azar</TD><TD>13991002</TD><TD>YGVQ</TD><TD>36</TD></TR><TR><TD>Azar</TD><TD>13991002</TD><TD>1101</TD><TD>34</TD></TR><TR><TD>Azar</TD><TD>13991002</TD><TD>1001</TD><TD>90</TD></TR><TR><TD>DAY</TD><TD>13991003</TD><TD>YGVQ</TD><TD>35</TD></TR><TR><TD>DAY</TD><TD>13991003</TD><TD>1101</TD><TD>60</TD></TR><TR><TD>DAY</TD><TD>13991004</TD><TD>YGVQ</TD><TD>38</TD></TR><TR><TD>DAY</TD><TD>13991004</TD><TD>1101</TD><TD>70</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE><TBODY><TR><TD>Date_S</TD><TD>Azar</TD><TD>DAY</TD></TR><TR><TD>13990927</TD><TD>94</TD><TD>&nbsp;</TD></TR><TR><TD>13990929</TD><TD>110</TD><TD>&nbsp;</TD></TR><TR><TD>13990930</TD><TD>126</TD><TD>&nbsp;</TD></TR><TR><TD>13991001</TD><TD>144</TD><TD>&nbsp;</TD></TR><TR><TD>13991002</TD><TD><FONT face="impact,chicago"><STRONG>160</STRONG></FONT></TD><TD>&nbsp;</TD></TR><TR><TD>13991003</TD><TD>&nbsp;</TD><TD>94</TD></TR><TR><TD>13991004</TD><TD>&nbsp;</TD><TD><FONT face="impact,chicago"><STRONG>108</STRONG></FONT></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Best wishes.</P><P>&nbsp;</P> Thu, 24 Dec 2020 09:58:45 GMT https://community.qlik.com/t5/QlikView/Conditional-Calculation-in-a-chart/m-p/1770413#M717047 Hamid_Reza_Rashidi 2020-12-24T09:58:45Z Re: Conditional Calculation in a chart https://community.qlik.com/t5/QlikView/Conditional-Calculation-in-a-chart/m-p/1770455#M717048 <P>if the requirement is to show only the ones in bold, try this expression:</P><LI-CODE lang="markup">= Sum( Aggr( If(Date_S = Max(TOTAL &lt;Ord_Mah&gt; Date_S), sum(Ord_QTY)) , Date_S, Ord_Mah ) ) </LI-CODE><P><BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="edwin_0-1608843940812.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/46132i48E23848723DB6D8/image-size/medium?v=v2&amp;px=400" role="button" title="edwin_0-1608843940812.png" alt="edwin_0-1608843940812.png" /></span></P><P>&nbsp;</P> Thu, 24 Dec 2020 21:06:08 GMT https://community.qlik.com/t5/QlikView/Conditional-Calculation-in-a-chart/m-p/1770455#M717048 edwin 2020-12-24T21:06:08Z