topic Error in calculated dimension in QlikView https://community.qlik.com/t5/QlikView/Error-in-calculated-dimension/m-p/272936#M1178716 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I am trying to generate a report using chart -&gt; straight table and would like to fitler the data. I have a straight table with all the columns as dimension and expression =1. the straight table gets generated properly but when i am trying to filter the data i am getting error in calculating the dimension".</P><P></P><P>I have the following data</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>Qty</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Price</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Buyer</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Seller</STRONG></SPAN></TH></TR><TR><TD>2000</TD><TD>2.0</TD><TD>ABC</TD><TD>XYZ</TD></TR><TR><TD>3000</TD><TD>2.2</TD><TD>ABC</TD><TD>PQR</TD></TR><TR><TD>3000</TD><TD>2.0</TD><TD>XYZ</TD><TD>PQR</TD></TR><TR><TD>4000</TD><TD>2.0</TD><TD>ABC</TD><TD>AAA</TD></TR></TBODY></TABLE><P></P><P>I have a list box containing all the buyer and seller and would like to filter the above data based on the selection in the list box.</P><P></P><P>i have the dimension for buyer as </P><P>only ({&lt;buyer = {"$(=getfieldselections(Firm))"}&gt; buyer) ... where Firm is the list box used for selection.</P><P></P><P>Kindly let me know how i can get this data filter...</P><P></P><P>Thanks and Regards,</P><P>Qaiyum</P></BODY></HTML> Sat, 11 Feb 2012 13:41:32 GMT 2012-02-11T13:41:32Z Error in calculated dimension https://community.qlik.com/t5/QlikView/Error-in-calculated-dimension/m-p/272936#M1178716 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I am trying to generate a report using chart -&gt; straight table and would like to fitler the data. I have a straight table with all the columns as dimension and expression =1. the straight table gets generated properly but when i am trying to filter the data i am getting error in calculating the dimension".</P><P></P><P>I have the following data</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>Qty</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Price</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Buyer</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Seller</STRONG></SPAN></TH></TR><TR><TD>2000</TD><TD>2.0</TD><TD>ABC</TD><TD>XYZ</TD></TR><TR><TD>3000</TD><TD>2.2</TD><TD>ABC</TD><TD>PQR</TD></TR><TR><TD>3000</TD><TD>2.0</TD><TD>XYZ</TD><TD>PQR</TD></TR><TR><TD>4000</TD><TD>2.0</TD><TD>ABC</TD><TD>AAA</TD></TR></TBODY></TABLE><P></P><P>I have a list box containing all the buyer and seller and would like to filter the above data based on the selection in the list box.</P><P></P><P>i have the dimension for buyer as </P><P>only ({&lt;buyer = {"$(=getfieldselections(Firm))"}&gt; buyer) ... where Firm is the list box used for selection.</P><P></P><P>Kindly let me know how i can get this data filter...</P><P></P><P>Thanks and Regards,</P><P>Qaiyum</P></BODY></HTML> Sat, 11 Feb 2012 13:41:32 GMT https://community.qlik.com/t5/QlikView/Error-in-calculated-dimension/m-p/272936#M1178716 2012-02-11T13:41:32Z Error in calculated dimension https://community.qlik.com/t5/QlikView/Error-in-calculated-dimension/m-p/272937#M1178717 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Sorry, for my previous post, I could not get your point correctly. </P><P>You have to use advanced aggregation, you can not use group functions directly in calculated dimensions.</P><P>Try this expression, it will work.</P><P></P><P>=aggr(only({&lt;Buyer={"$(=GetFieldSelections(Firm))"}&gt;} Buyer),Buyer)</P><P></P><P>Let me know, if any issue.</P><P>..</P><P>Ashutosh</P></BODY></HTML> Sat, 11 Feb 2012 18:34:55 GMT https://community.qlik.com/t5/QlikView/Error-in-calculated-dimension/m-p/272937#M1178717 2012-02-11T18:34:55Z