Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
so this is not possible?
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.
This way?
Well, this could be an option... How did you make this column so slim?
As i told you before, we can make thAT column hidden with the help of macros.
But macros are not safe and not recommended.
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.