topic chart color, alternate in rows in QlikView

chart color, alternate in rows

Mon, 10 Nov 2014 12:29:59 GMT

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

Re: chart color, alternate in rows

Mon, 10 Nov 2014 12:36:14 GMT

i guess

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

Re: chart color, alternate in rows

Mon, 10 Nov 2014 12:43:11 GMT

i think it is for bar chart

Re: chart color, alternate in rows

its_anandrjs — Mon, 10 Nov 2014 12:43:24 GMT

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

Regards

Anand

Re: chart color, alternate in rows

Mon, 10 Nov 2014 12:44:13 GMT

Hi,

try this in the back ground colour

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

Re: chart color, alternate in rows

simenkg — Mon, 10 Nov 2014 12:44:31 GMT

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())

Re: chart color, alternate in rows

jagan — Mon, 10 Nov 2014 12:46:31 GMT

Hi,

Try like this

Properties->Style->Current Style -> Basic

Stripes every 1 Rows

Regards,

JagaN

Re: Re: chart color, alternate in rows

anbu1984 — Mon, 10 Nov 2014 12:47:10 GMT

Check this app

Re: chart color, alternate in rows

Mon, 10 Nov 2014 12:51:56 GMT

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

Re: Re: chart color, alternate in rows

its_anandrjs — Mon, 10 Nov 2014 12:55:15 GMT

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

Re: chart color, alternate in rows

Mon, 10 Nov 2014 12:57:50 GMT

ok... one question is ..

i have the same setting in my qlikview that is installed on my machine and save the document with same setting.

now if any other user open same document on other machine and he has not enable the same setting .. is he able to see all this color changes??

Re: Re: chart color, alternate in rows

its_anandrjs — Mon, 10 Nov 2014 13:03:17 GMT

Yes he can view same settings even the tab that you open last and close there it is view to the other also. And if the application is view from QV access point no one can able to change any settings.

Regards

Anand

Re: chart color, alternate in rows

Mon, 10 Nov 2014 13:11:52 GMT

thanks all of you

Re: chart color, alternate in rows

KPL69 — Thu, 29 Feb 2024 04:31:19 GMT

Hi Anand

How do you do the alternating colour for an the entire row based on the change of a particular field value?