topic How to filter 1 column based another when creating a chart? in QlikView https://community.qlik.com/t5/QlikView/How-to-filter-1-column-based-another-when-creating-a-chart/m-p/438138#M561688 <HTML><HEAD></HEAD><BODY><P>Sorry for the basic questions - I am really new to Qlikview...</P><P></P><P>I have a dataset which includes fields similar to the ones below.&nbsp; I want to create a table that shows the the sum of the calculated column, but only where Text = 'A'</P><P></P><P>Could anyone suggest a good way of doing this?</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Text</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Calculation</STRONG></SPAN></TH></TR><TR><TD>A</TD><TD>=if(Sum(X)=0,null, Sum(X)/Sum(y)</TD></TR><TR><TD>A</TD><TD>=if(Sum(X)=0,null, Sum(X)/Sum(y)</TD></TR><TR><TD>B</TD><TD>=if(Sum(X)=0,null, Sum(X)/Sum(y)</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 13 Mar 2013 16:59:09 GMT 2013-03-13T16:59:09Z How to filter 1 column based another when creating a chart? https://community.qlik.com/t5/QlikView/How-to-filter-1-column-based-another-when-creating-a-chart/m-p/438138#M561688 <HTML><HEAD></HEAD><BODY><P>Sorry for the basic questions - I am really new to Qlikview...</P><P></P><P>I have a dataset which includes fields similar to the ones below.&nbsp; I want to create a table that shows the the sum of the calculated column, but only where Text = 'A'</P><P></P><P>Could anyone suggest a good way of doing this?</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Text</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Calculation</STRONG></SPAN></TH></TR><TR><TD>A</TD><TD>=if(Sum(X)=0,null, Sum(X)/Sum(y)</TD></TR><TR><TD>A</TD><TD>=if(Sum(X)=0,null, Sum(X)/Sum(y)</TD></TR><TR><TD>B</TD><TD>=if(Sum(X)=0,null, Sum(X)/Sum(y)</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 13 Mar 2013 16:59:09 GMT https://community.qlik.com/t5/QlikView/How-to-filter-1-column-based-another-when-creating-a-chart/m-p/438138#M561688 2013-03-13T16:59:09Z Re: How to filter 1 column based another when creating a chart? https://community.qlik.com/t5/QlikView/How-to-filter-1-column-based-another-when-creating-a-chart/m-p/438139#M561689 <HTML><HEAD></HEAD><BODY><P>try this:</P><P></P><P></P><P>sum({&lt;Text={'A'}&gt;}X)</P></BODY></HTML> Wed, 13 Mar 2013 17:01:58 GMT https://community.qlik.com/t5/QlikView/How-to-filter-1-column-based-another-when-creating-a-chart/m-p/438139#M561689 sushil353 2013-03-13T17:01:58Z