Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
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
Partner

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

Hi Jan,

Try to use Dimensionality function instead:

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

Hope it will help