Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
TBQlikNewbi
Contributor II
Contributor II

Coloring total row

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

11 Replies
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
Contributor II
Contributor II
Author

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
Partner
Partner

@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:

image.png

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
Partner
Partner

Hi Eli,

Where does this css file located?

Thanks,

Arthur Fong

EliGohar
Partner
Partner

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

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

Arthur_Fong
Partner
Partner

Does it also applicable for desktop version?

I am testing on my local right now.

Thanks.

Arthur_Fong
Partner
Partner

I couldn't find Qlik folder under Program Files.

mfarsln
Creator II
Creator II

Hi,

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

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