topic Re: Paint rows? in QlikView

Paint rows?

Thu, 10 Sep 2015 18:35:57 GMT

Can i paint one row, and don't paint the another, and so on ? It's to read more clearly.

Greetings

Re: Paint rows?

jduenyas — Thu, 10 Sep 2015 18:40:18 GMT

Yes you can.

In the properties sheet, go to Style and select under Current Style Pyjama Green and then in strips every... select how frequently you want to alternate colors

Re: Paint rows?

sudeepkm — Thu, 10 Sep 2015 18:42:56 GMT

have you already tried Stripes every "#" row option available under Style of the chart properties.

Re: Paint rows?

Thu, 10 Sep 2015 18:44:03 GMT

I see the option but i cannot use it. Do you know why?

Re: Paint rows?

sunny_talwar — Thu, 10 Sep 2015 18:46:16 GMT

Color alternate rows?

Re: Paint rows?

sudeepkm — Thu, 10 Sep 2015 18:46:30 GMT

are you using Pivot table??

Re: Paint rows?

Thu, 10 Sep 2015 18:48:33 GMT

yeah. it was that

can't i do it in the pivot tables?

regards

Re: Paint rows?

sudeepkm — Thu, 10 Sep 2015 19:04:48 GMT

yes. it is possible but not through Style options.

you can use an expression like below to achieve it.

Identify each row using rowno() and then paint even numbered rows with one color and odd numbered rows with other color by using Background color available for dimension and expression. Even function can tell you whether a number is even or odd like below

Re: Paint rows?

qlikviewwizard — Thu, 10 Sep 2015 23:44:23 GMT

Hi Sunny, Seems yes alternative row feature of SAP BO.