topic Re: Background color expression conditional on Dimension in QlikView

Background color expression conditional on Dimension

Tue, 09 Jun 2015 09:16:13 GMT

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 €

Re: Background color expression conditional on Dimension

qlikmsg4u — Tue, 09 Jun 2015 09:18:57 GMT

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

Re: Background color expression conditional on Dimension

sushil353 — Tue, 09 Jun 2015 09:19:50 GMT

Hi,

Try below:

Under expression > background color

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

HTH

Sushil

Re: Background color expression conditional on Dimension

Tue, 09 Jun 2015 09:28:22 GMT

Hi,

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

Re: Background color expression conditional on Dimension

qlikmsg4u — Tue, 09 Jun 2015 09:43:13 GMT

Hi,

In Qliksense there is only Expression/Measure colour formatting.

Re: Background color expression conditional on Dimension

Tue, 09 Jun 2015 09:56:38 GMT

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.

Re: Background color expression conditional on Dimension

sushil353 — Tue, 09 Jun 2015 10:05:43 GMT

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

Re: Background color expression conditional on Dimension

Tue, 09 Jun 2015 10:42:04 GMT

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

Re: Background color expression conditional on Dimension

humesh_sindpure — Fri, 13 Apr 2018 05:53:17 GMT

can you show me the code for this