topic Re: Sorting by expressions in charts when using inter record functions in attribute expressions in QlikView https://community.qlik.com/t5/QlikView/Sorting-by-expressions-in-charts-when-using-inter-record/m-p/380963#M570749 <HTML><HEAD></HEAD><BODY><P>Hi Jan,</P><P></P><P>Try to use Dimensionality function instead:</P><P></P><P><CODE class="jive-code">=if(Dimensionality()&gt;0 and SomeOtherCondition, RGB(255,0,0))</CODE></P><P></P><P>Hope it will help</P></BODY></HTML> Sun, 26 Aug 2012 14:32:41 GMT bgerchikov 2012-08-26T14:32:41Z Sorting by expressions in charts when using inter record functions in attribute expressions https://community.qlik.com/t5/QlikView/Sorting-by-expressions-in-charts-when-using-inter-record/m-p/380962#M570748 <HTML><HEAD></HEAD><BODY><P>I have been trying to use inter record functions in the attribute expression of a straight chart. The purpose was to exclude the totals row from the formatting. The expression I used to define the background color looks like this:</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13459781960775509" jivemacro_uid="_13459781960775509"><P>=if(RowNo()&gt;0 and SomeOtherCondition, RGB(255,0,0))</P></PRE><P></P><P>It seems however that whenever I introduce a chart inter-record function (RowNo() in the example) into an attribute expression, it is no longer possible to sort the table on an expression, but only on dimensions.</P><P></P><P>Has anyone else experienced this problem? And are there any ideas on how to overcome this?</P></BODY></HTML> Sun, 26 Aug 2012 10:49:40 GMT https://community.qlik.com/t5/QlikView/Sorting-by-expressions-in-charts-when-using-inter-record/m-p/380962#M570748 2012-08-26T10:49:40Z Re: Sorting by expressions in charts when using inter record functions in attribute expressions https://community.qlik.com/t5/QlikView/Sorting-by-expressions-in-charts-when-using-inter-record/m-p/380963#M570749 <HTML><HEAD></HEAD><BODY><P>Hi Jan,</P><P></P><P>Try to use Dimensionality function instead:</P><P></P><P><CODE class="jive-code">=if(Dimensionality()&gt;0 and SomeOtherCondition, RGB(255,0,0))</CODE></P><P></P><P>Hope it will help</P></BODY></HTML> Sun, 26 Aug 2012 14:32:41 GMT https://community.qlik.com/t5/QlikView/Sorting-by-expressions-in-charts-when-using-inter-record/m-p/380963#M570749 bgerchikov 2012-08-26T14:32:41Z