topic Re: Coloring total row in App Development

Coloring total row

TBQlikNewbi — Fri, 21 Jun 2019 18:41:29 GMT

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

Re: Coloring total row

rwunderlich — Sat, 22 Jun 2019 00:11:09 GMT

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

Re: Coloring total row

TBQlikNewbi — Tue, 25 Jun 2019 15:10:13 GMT

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

Re: Coloring total row

EliGohar — Wed, 26 Jun 2019 07:15:41 GMT

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

Re: Coloring total row

rwunderlich — Mon, 26 Aug 2019 21:01:40 GMT

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

Re: Coloring total row

Arthur_Fong — Tue, 27 Aug 2019 06:41:14 GMT

Hi Eli,

Where does this css file located?

Thanks,

Arthur Fong

Re: Coloring total row

EliGohar — Tue, 27 Aug 2019 06:43:35 GMT

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

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

Re: Coloring total row

Arthur_Fong — Tue, 27 Aug 2019 06:44:47 GMT

Does it also applicable for desktop version?

I am testing on my local right now.

Thanks.

Re: Coloring total row

Arthur_Fong — Tue, 27 Aug 2019 06:47:49 GMT

I couldn't find Qlik folder under Program Files.

Re: Coloring total row

mfarsln — Tue, 27 Aug 2019 06:55:38 GMT

Hi,

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

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

Re: Coloring total row

Arthur_Fong — Tue, 27 Aug 2019 07:01:00 GMT

Hi,

After downloading, where should i place this theme file?

Re: Coloring total row

mfarsln — Tue, 27 Aug 2019 07:08:16 GMT

If you are using desktop, you should place it under '\\Documents\Qlik\Sense\Extensions'

If you are using server, you should import it as an extension from qmc.