Background Color Pivot chart (if one dimension on top)

[richters]

Hi all,

I created a pivot chart and want to highlight every second row. So I gave every formula and dimension a background formula as followed:

=if(mod(rowno(),2)=0,LightGray(80))

Is it possible to give the cells in red a background color?

Thanks a lot!

[richters]

so this is not possible?

[Qrishna]

its possible only by changing the width of the empty column by using a macro and suppress the width to zero so that you wont be able to see that empty column.

But as far as i am aware,NO you cannot color that empty column.

You can contact Qlik and ask them for some macros or any other kind of script.

[Qrishna]

This way?

[richters]

Well, this could be an option... How did you make this column so slim?

[Qrishna]

As i told you before, we can make thAT column hidden with the help of macros.

But macros are not safe and not recommended.

[Anonymous]

Hi Sabrina,

Don't know if you already found a solution or not but take a look at the attached Qliview document, maybe it is usefull.

Like mentioned by others, the colors colors does not work when the result is 0.

What I did is :

IF(SUM(YourExpression)=0,'-', SUM(YourExpression))

It worked for me.

Kind regards,

Dennis.