topic Re: Seperate total Values in QlikView

topic Re: Seperate total Values in QlikView https://community.qlik.com/t5/QlikView/Seperate-total-Values/m-p/465434#M560882 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>     Try your expression for Amt as below.</P><P></P><P>     Sum(total <Month> Amt)</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Thu, 18 Apr 2013 06:58:03 GMT kaushiknsolanki 2013-04-18T06:58:03Z Seperate total Values https://community.qlik.com/t5/QlikView/Seperate-total-Values/m-p/465433#M560881 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I'm currently having problems seperating total values on my pivot chart.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 294px;"><TBODY><TR><TD class="xl63" height="17" width="98">Month</TD><TD class="xl64" style="border-left: none;" width="98">Segment</TD><TD class="xl65" width="98">Amt</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Oct</TD><TD class="xl65" style="border-top: none; border-left: none;"> </TD><TD class="xl65" style="border-top: none; border-left: none;">20788814.93</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Oct</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">20788814.93</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Oct</TD><TD class="xl65" style="border-top: none; border-left: none;">B</TD><TD class="xl65" style="border-top: none; border-left: none;">20788814.93</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Oct</TD><TD class="xl65" style="border-top: none; border-left: none;">C</TD><TD class="xl65" style="border-top: none; border-left: none;">20788814.93</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Oct</TD><TD class="xl65" style="border-top: none; border-left: none;">D</TD><TD class="xl65" style="border-top: none; border-left: none;">20788814.93</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Oct</TD><TD class="xl65" style="border-top: none; border-left: none;">E</TD><TD class="xl65" style="border-top: none; border-left: none;">20788814.93</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Oct</TD><TD class="xl65" style="border-top: none; border-left: none;">F</TD><TD class="xl65" style="border-top: none; border-left: none;">20788814.93</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Oct</TD><TD class="xl65" style="border-top: none; border-left: none;">-</TD><TD class="xl65" style="border-top: none; border-left: none;">20788814.93</TD></TR></TBODY></TABLE><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 294px;"><TBODY><TR><TD class="xl63" height="17" width="98">Month</TD><TD class="xl64" style="border-left: none;" width="98">Segment</TD><TD class="xl65" width="98">Amt</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Nov</TD><TD class="xl65" style="border-top: none; border-left: none;"> </TD><TD class="xl65" style="border-top: none; border-left: none;">19838230.06</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Nov</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">19838230.06</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Nov</TD><TD class="xl65" style="border-top: none; border-left: none;">B</TD><TD class="xl65" style="border-top: none; border-left: none;">19838230.06</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Nov</TD><TD class="xl65" style="border-top: none; border-left: none;">C</TD><TD class="xl65" style="border-top: none; border-left: none;">19838230.06</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Nov</TD><TD class="xl65" style="border-top: none; border-left: none;">D</TD><TD class="xl65" style="border-top: none; border-left: none;">19838230.06</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Nov</TD><TD class="xl65" style="border-top: none; border-left: none;">E</TD><TD class="xl65" style="border-top: none; border-left: none;">19838230.06</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Nov</TD><TD class="xl65" style="border-top: none; border-left: none;">F</TD><TD class="xl65" style="border-top: none; border-left: none;">19838230.06</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Nov</TD><TD class="xl65" style="border-top: none; border-left: none;">-</TD><TD class="xl65" style="border-top: none; border-left: none;">19838230.06</TD></TR><TR><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR></TBODY></TABLE><P></P><P></P><P></P><P></P><P>Now, When I select both <STRONG>MONTH</STRONG>. </P><P></P><P></P><TABLE><TBODY><TR><TD>Month</TD><TD>Segment</TD><TD>Amt</TD></TR><TR><TD>Oct</TD><TD><BR /></TD><TD>40627044.99</TD></TR><TR><TD>Oct</TD><TD>A</TD><TD>40627044.99</TD></TR><TR><TD>Oct</TD><TD>B</TD><TD>40627044.99</TD></TR><TR><TD>Oct</TD><TD>C</TD><TD>40627044.99</TD></TR><TR><TD>Oct</TD><TD>D</TD><TD>40627044.99</TD></TR><TR><TD>Oct</TD><TD>E</TD><TD>40627044.99</TD></TR><TR><TD>Oct</TD><TD>F</TD><TD>40627044.99</TD></TR><TR><TD>Oct</TD><TD>-</TD><TD>40627044.99</TD></TR><TR><TD>Nov</TD><TD><BR /></TD><TD>40627044.99</TD></TR><TR><TD>Nov</TD><TD>A</TD><TD>40627044.99</TD></TR><TR><TD>Nov</TD><TD>B</TD><TD>40627044.99</TD></TR><TR><TD>Nov</TD><TD>C</TD><TD>40627044.99</TD></TR><TR><TD>Nov</TD><TD>D</TD><TD>40627044.99</TD></TR><TR><TD>Nov</TD><TD>E</TD><TD>40627044.99</TD></TR><TR><TD>Nov</TD><TD>F</TD><TD>40627044.99</TD></TR><TR><TD>Nov</TD><TD>-</TD><TD>40627044.99</TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>It totals up Oct & Nov. IS there any way I can seperate the values?</P><P>I am using the <STRONG>total</STRONG> in the expression</P><P></P><P>Thanks</P></BODY></HTML> Thu, 18 Apr 2013 03:45:18 GMT https://community.qlik.com/t5/QlikView/Seperate-total-Values/m-p/465433#M560881 2013-04-18T03:45:18Z Re: Seperate total Values https://community.qlik.com/t5/QlikView/Seperate-total-Values/m-p/465434#M560882 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>     Try your expression for Amt as below.</P><P></P><P>     Sum(total <Month> Amt)</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Thu, 18 Apr 2013 06:58:03 GMT https://community.qlik.com/t5/QlikView/Seperate-total-Values/m-p/465434#M560882 kaushiknsolanki 2013-04-18T06:58:03Z