Background color expression conditional on Dimension

[#1]

Hi,

How can I change the background color of certain cells conditional on the dimension of the table? Here is what I want to achieve. So basically change the the color of every other row. I'm thinking this could be done by conditional on Bob and Joe, but if there are easier ways to do this I would really appreciate the help.

Thanks.

Person	Sales	Inbound	Outbound
Bob	169,94 €	497,16 €	751,65 €
Sam	815,37 €	414,82 €	256,28 €
Joe	628,56 €	791,40 €	849,71 €

[qlikmsg4u]

if you want to change colour of alternate rows just go to properties > style > Change Stripes every 1 row

[sushil353]

Hi,

Try below:

Under expression > background color

=if(Mod(RowNo(),2)=0,blue(),white())

HTH

Sushil

[#4]

Hi,

I should have mentioned that I am using Qliksense. Is there still a way to do this?

[qlikmsg4u]

Hi,

In Qliksense there is only Expression/Measure colour formatting.

[#6]

Hi Sushil,

Is there a way to just change the color for the grand total? Currently I am using if(RowNo()=0,xxx,yyy) to change the colors for subtotals but it is not picking up the grand total. Appreciate your help.

[sushil353]

Hi,

Try below steps:

1. Settings>User preferences > Design > check the option "Always Show design Menu Items"

2. Now goto your table and just take ur mouse courser on grand total cell and do right click.. Select the option > custom format cell and then change the background color.

HTH

Sushil

[#8]

Is there a way (script) to do this in Qliksense?

[humesh_sindpure]

can you show me the code for this