Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

chart color, alternate in rows

i want to fill table chart with alternate color in rows.

row1 - green

row2- blue

row3- green

row4- blue

i have enable the setting from user preferences  - > design -> always show design menu

in custom format cell - background color i expression is

if(mod(RowNo(total),2)=0,green(),blue())



but it is not working


1 Solution

Accepted Solutions
its_anandrjs

Hi.

In the dimension EMPNO click on  ( + ) and in Background write expression

=if(mod(RowNo(total),2)=0,green(),blue())

and in Text Color write expression

=if(mod(RowNo(total),2)=0,White(),White())

In your app you can find here

Color.png

Regards

Anand

View solution in original post

13 Replies
Not applicable
Author

i guess

in color tab u have  clor appreance   1-6  change there based on ur colour requirment

Not applicable
Author

i think it is for bar chart

its_anandrjs

Hi.

In the dimension EMPNO click on  ( + ) and in Background write expression

=if(mod(RowNo(total),2)=0,green(),blue())

and in Text Color write expression

=if(mod(RowNo(total),2)=0,White(),White())

In your app you can find here

Color.png

Regards

Anand

Not applicable
Author

Hi,

try this in the back ground colour

if(mod(RowNo(),2)=0,green(),blue())


simenkg
Specialist
Specialist

In your expression and dimension tabs. Expand the dimension and expression by pressing the [+] next to it. Under Background Color or Text Color, insert your expression:


if(mod(RowNo(total),2)=0,green(),blue())

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

Properties->Style->Current Style -> Basic

Stripes every 1 Rows

Regards,

JagaN

anbu1984
Master III
Master III

Check this app

Not applicable
Author

and how we can change dimension, expression label background color ??????????

its_anandrjs

Hi,

For this you have to use Custom Format Cell to check it is enable or not go to settings >> user preference >> Design >> check Always Show design Menu selected or deselected if deselect then select it. And this option Custom Format Cell is view-able by right click on the dimension and expression label.

Regards

Anand