topic calculated dimension in QlikView https://community.qlik.com/t5/QlikView/calculated-dimension/m-p/536513#M200560 <HTML><HEAD></HEAD><BODY><TABLE border="1" class="jiveBorder" height="75" style="border: 1px solid rgb(0, 0, 0); width: 250px; height: 31px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Range</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Count</TH><STRONG>value<BR /></STRONG></TR><TR><TD style="padding: 2px;">0-1</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">89</TD></TR><TR><TD style="padding: 2px;">0-1</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;"><P>100</P></TD></TR></TBODY></TABLE><P></P><P>Is there a way to only display row 2 in a pivot table?</P><P></P><P>IF(Count = max(Count),ONLY(Range))&nbsp; does not give the desired result. I just want to display row number 2 only.</P><P></P><P>Thanks</P></BODY></HTML> Mon, 28 Oct 2013 15:42:46 GMT Anonymous 2013-10-28T15:42:46Z calculated dimension https://community.qlik.com/t5/QlikView/calculated-dimension/m-p/536513#M200560 <HTML><HEAD></HEAD><BODY><TABLE border="1" class="jiveBorder" height="75" style="border: 1px solid rgb(0, 0, 0); width: 250px; height: 31px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Range</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Count</TH><STRONG>value<BR /></STRONG></TR><TR><TD style="padding: 2px;">0-1</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">89</TD></TR><TR><TD style="padding: 2px;">0-1</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;"><P>100</P></TD></TR></TBODY></TABLE><P></P><P>Is there a way to only display row 2 in a pivot table?</P><P></P><P>IF(Count = max(Count),ONLY(Range))&nbsp; does not give the desired result. I just want to display row number 2 only.</P><P></P><P>Thanks</P></BODY></HTML> Mon, 28 Oct 2013 15:42:46 GMT https://community.qlik.com/t5/QlikView/calculated-dimension/m-p/536513#M200560 Anonymous 2013-10-28T15:42:46Z Re: calculated dimension https://community.qlik.com/t5/QlikView/calculated-dimension/m-p/536514#M200561 <HTML><HEAD></HEAD><BODY><P>Try expression like:</P><P>=AGGR (<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">IF(Count = max(total Count), Range) , Range, Count)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">And the check 'Suppress When Value is Null' in the dimension tab&nbsp; </SPAN></P></BODY></HTML> Mon, 28 Oct 2013 15:49:40 GMT https://community.qlik.com/t5/QlikView/calculated-dimension/m-p/536514#M200561 tresB 2013-10-28T15:49:40Z