Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Paint rows?

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

Greetings

1 Solution

Accepted Solutions
sudeepkm
Specialist III
Specialist III

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

T171982.PNG

View solution in original post

8 Replies
jduenyas
Specialist
Specialist

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

sudeepkm
Specialist III
Specialist III

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

T180065.PNG

Not applicable
Author

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

sunny_talwar

Color alternate rows?

sudeepkm
Specialist III
Specialist III

are you using Pivot table??

Not applicable
Author

yeah. it was that

can't i do it in the pivot tables?

regards

sudeepkm
Specialist III
Specialist III

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

T171982.PNG

qlikviewwizard
Master II
Master II

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