Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

Alternate color problem in pivot

Hi,

I have a problem with in a pivot table where I am using this formula to alternate rows colors, but when there is a null row value it doesn't work well.

Screen to see my problem

How can I resolve?

FORMULA:

= if(
Dimensionality()= 0,
$(vTotalPivotColor),
if (Dimensionality()= 1,
if (even(RowNo(total))=0, $(vAlternate1PivotColor),
if (even(RowNo(total))=-1, $(vAlternate2PivotColor),
if (isnull(even(RowNo(total))),
$(vAlternate1PivotColor)))),
if((Dimensionality()> 1),$(vExpandPivotColor))))

 

where variables are RGB colors

5 Replies
Highlighted

Re: Alternate color problem in pivot

Did you apply the "Color as Measure" ??
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Contributor
Contributor

Re: Alternate color problem in pivot

no, I need to use this colors
Highlighted
Partner
Partner

Re: Alternate color problem in pivot

Null cells will always be colored grey no matter what u do
Highlighted
Contributor
Contributor

Re: Alternate color problem in pivot

okay, but how to alternate color the others without problems?
Highlighted
Partner
Partner

Re: Alternate color problem in pivot

Hello!

This is due to the fact that a pivot table is merely a visual representation of a straight table in memory. Try selecting "View Data" in the chart's context (right-click) menu to see how the data really "looks".

RowNo() is calculated from the "straight" table. Not from the pivot visual representation of it; that's why it is seldom useful in pivot tables.

You may try to use if(even(fieldindex('FieldName',Fieldname))=0,blue()) to at least avoid alternating colors in cells belonging to the same pivot "row".

"FieldName" must be one of the dimensions you are using as "rows" in the pivot table. Experiment with this and you may find a satisfactory look; the appearance will vary depending on the expansion state of your pivot table and the presence of null values.