Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

Chart total cell background

Hi,

How to remove the dark area on total.Below is the image.

Table used: Straight Table.

Untitled.png

Thanks..

12 Replies
sunny_talwar

Enable the total to show expression total (on the expression tab under total mode) and then use this expression:

If(Dimensionality() = 0, ' ', YourCurrentExpression)

Chanty4u
MVP
MVP

is this?

isthis.PNG

nareshthavidishetty
Creator III
Creator III
Author

Hi,

Below is the logic

if (Dimensionality() = 0, ' ',if(New_A7AIDT= min(New_A7AIDT),New_A7AIDT,min(New_A7AIDT)))

Below is the O/P it haven't change and the dates were also showing different.

Untitled.png

Thanks..

nareshthavidishetty
Creator III
Creator III
Author

Yes! suresh exacltly..

sunny_talwar

Have you already changed the total mode?

Capture.PNG

Chanty4u
MVP
MVP

ohhh ... am nt sure if u satisfied with abve solution 

den ---goto style tab-->chnge the current style to  -->wacky

nareshthavidishetty
Creator III
Creator III
Author

Hi,

I have already change it to total mode.Below is the pic for reference.

Untitled.png

Frank_Hartmann
Master II
Master II

You could also change backgroundcolor by right clicking in the Total Field an select the "Custom Format Cell"

Then you have the option to change Color for this field!

hope this helps:

Unbenannt.png

nareshthavidishetty
Creator III
Creator III
Author

Hi,

Tried with custom format cell..But the cell itself is not able to select means it is showing no cell.

Thanks..