Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
stevelord
Specialist
Specialist

Better distinguish the Totals row in straight table?

Hi Community,

A colleague has asked if there is a way for me to put the word Total: or maybe do some conditional formatting or some other thing on the totals row only to distinguish it better from everything below.  This came up because one of the columns has a count of the id #s below it, and there is (some mild) concern that count will be mistaken as an id # itself (even though the totals row is in bold already and # of digits are different).

EventId  Attended

212       100

48638    25

48639    25

48640    25

...           ...

I did look at visual cues and things like that, and saw conditional formatting for number ranges and things, but not sure how to target that to the totals row (max/highest value in column maybe if available, but two columns are avg %), nor how to just stick the word Totals on the totals row.

Thanks!

1 Solution

Accepted Solutions
jerem1234
Specialist II
Specialist II

You can try to change the text color of the total. If you click on the plus sign next the the expression on the expression tab, then put a formula in for Text Color like:

if(dimensionality()=0, red())

That will change the color of the total to red so it distinguishes it from other values. Of course you dont have to use red, use whatever you want or use rgb().

Hope this helps!

View solution in original post

5 Replies
stevelord
Specialist
Specialist
Author

and yes it's a five second thing for me to insert the column in excel and write the word Total: or whatever, but this is a daily first thing in the morning report (with many more super columns and expressions) going to top priority recipient, so making sure stuff is pristine with minimal manual intervention on any aspect before I try to hand it off.

jerem1234
Specialist II
Specialist II

You can try to change the text color of the total. If you click on the plus sign next the the expression on the expression tab, then put a formula in for Text Color like:

if(dimensionality()=0, red())

That will change the color of the total to red so it distinguishes it from other values. Of course you dont have to use red, use whatever you want or use rgb().

Hope this helps!

stevelord
Specialist
Specialist
Author

Great thanks, I learned something new.  I also looked up dimensionality() to see what that does and this community post broke that out very simply for me as well: Dimensionality Function and its types

Your answer was correct, I just looked up that function to see why your answer was correct.

Funny story, recipient wants the file as csv and conditional formatting falls out anyway.  So colleague just made it very very clear to recipient 'that top row, the one where the location names are blank, is the totals row'.  Fear all the '0-skill' stuff I have to make.

Not applicable

Hi Steve,

you might also want to take a look at the 'Custom Format Cell' properties of the chart too, can do some useful things with that without adding expression overhead to the chart

hope that helps

Joe

stevelord
Specialist
Specialist
Author

gratzi!