Coloring total row

[TBQlikNewbi]

I want to color the totals row in a straight table.  Not finding anything that works so far.

[rwunderlich]

Add the measure 

=Dimensionality()

to your table as a learning exercise.  You'll see that your total row(s) have a different value for the total row.  So for example, you can use a background color expression like:

=if(DImensionality() = 1, green(), white())

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[TBQlikNewbi]

Thanks for your response.  I did as you suggested, and the number in my "=Dimensionality()" measure column is 3, and in the totals row it is 0.  So I put this expression for background color in the dimensionality() measure column:

=if(Dimensionality() = 0, LightGray(), White())

And still, no color change ....

[EliGohar]

@TBQlikNewbi 

This can be easily made within the CSS file but I'm not sure you want to touch it 🙂

Anyway, I'm attaching the solution, you'll need to change the following class within the client.css file:

.qv-st-header .qv-st-total-cell {
    border-bottom: 1px solid #a6a6a6;
    background: blueviolet;
}

I gave the background property the color of blueviolet.

Result:

Eli.

[rwunderlich]

Coming back to this  late I know.  It looks like Qlik Sense does not apply background color expression to the Totals row in any circumstance.

-Rob

[Arthur_Fong]

Hi Eli,

Where does this css file located?

Thanks,

Arthur Fong

[EliGohar]

C:\Program Files\Qlik\Sense\Client\assets\client

But I prefer to use a custom theme and edit it's CSS file.

[Arthur_Fong]

Does it also applicable for desktop version?

I am testing on my local right now.

Thanks.

[Arthur_Fong]

I couldn't find Qlik folder under Program Files.

[mfarsln]

Hi,

Just create or download any custom theme, then customize its' .css file.

You can download custom theme from; https://sensetheme.com/