Skip to main content
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sorting by expressions in charts when using inter record functions in attribute expressions

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:

=if(RowNo()>0 and SomeOtherCondition, RGB(255,0,0))

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.

Has anyone else experienced this problem? And are there any ideas on how to overcome this?

1 Reply
Partner - Creator III
Partner - Creator III

Hi Jan,

Try to use Dimensionality function instead:

=if(Dimensionality()>0 and SomeOtherCondition, RGB(255,0,0))

Hope it will help