topic Re: Colour entire row in QlikView

Colour entire row

Thu, 13 Aug 2015 07:12:36 GMT

Hello All,

I am having a small issue with colours. I need to colour the entire row based on my campaign name but I can only colour the cell.

The current formula which I am using in my Dimension is:

=if(Nom_campagne='AAAAAAAA',RGB(119,119,119),

if(Nom_campagne='BBBBBBBBB',RGB(0,105,210)))

Any Idea please?

Many Thanks,

Hasvine

Re: Colour entire row

jonathandienst — Thu, 13 Aug 2015 07:14:16 GMT

Use the same background color expression for the expressions as well.

Re: Colour entire row

kavita25 — Thu, 13 Aug 2015 07:14:42 GMT

Post a sample app, with expected output

Re: Colour entire row

awhitfield — Thu, 13 Aug 2015 08:47:06 GMT

Hi Hasvine,

repeat the background colour expression for all dimensions and expression in the chart.

Andy

Re: Colour entire row

jagan — Thu, 13 Aug 2015 09:07:52 GMT

Hi,

You have to copy the expression to all expressions and dimensions then only it is possible.

Regards,

Jagan.

Re: Colour entire row

vardhancse — Thu, 13 Aug 2015 09:21:57 GMT

Hi,

Right click on the table->Custom Format Cell->Apply change to All dimensions/measures.

give the condition so that all the rows color will be changed

Re: Colour entire row

qlikviewwizard — Thu, 13 Aug 2015 10:57:43 GMT

‌hi Hasvine ,

did you manage to solve the issu?

Re: Colour entire row

Fri, 14 Aug 2015 06:57:53 GMT

No I had to colour row by row.

Re: Colour entire row

vardhancse — Fri, 14 Aug 2015 07:01:05 GMT

Dimensions/expressions.?

Re: Colour entire row

Fri, 14 Aug 2015 08:01:20 GMT

Both dimensions and expressions

Re: Colour entire row

jonathandienst — Fri, 14 Aug 2015 08:10:30 GMT

You have had three correct solutions above - from me, from awhitfield, from jagan

Did you try them at all?