topic Re: Formating based on chart row number in QlikView

Formating based on chart row number

martynlloyd — Mon, 11 May 2015 13:56:04 GMT

Hi,

Is there a variable for the row in a pivot or straight table chart?

I want to assign a different background colour to the first six rows of a chart.

Note: it is not possible for me to do this by comparing a field in the chart - i know how to do that...

best regards,

Marty.

Re: Formating based on chart row number

sunny_talwar — Mon, 11 May 2015 13:59:28 GMT

You can use RowNo() function. I would first create an expression =RowNo() and see what values it assigns to each row and then use it in my Background color expression accordingly.

HTH

Best,

Sunny

Re: Formating based on chart row number

sunilkumarqv — Mon, 11 May 2015 14:00:37 GMT

Yes

Re: Formating based on chart row number

awhitfield — Mon, 11 May 2015 14:05:05 GMT

Hi Martyn,

Add =If(RowNo()<=6,LightRed())

to each dimension and expression in the 'Background Colour'

HTH

Andy