Qlik Community

App Development

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

Announcements
QlikWorld online is next week! REGISTER NOW
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/