topic Re: Chart total cell background in QlikView

Chart total cell background

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

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

Table used: Straight Table.

Thanks..

Re: Chart total cell background

sunny_talwar — Thu, 07 Jul 2016 10:37:04 GMT

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

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

Re: Chart total cell background

Chanty4u — Thu, 07 Jul 2016 10:40:16 GMT

is this?

Re: Chart total cell background

nareshthavidishetty — Thu, 07 Jul 2016 11:00:39 GMT

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.

Thanks..

Re: Chart total cell background

nareshthavidishetty — Thu, 07 Jul 2016 11:01:08 GMT

Yes! suresh exacltly..

Re: Chart total cell background

sunny_talwar — Thu, 07 Jul 2016 11:04:07 GMT

Have you already changed the total mode?

Re: Chart total cell background

Chanty4u — Thu, 07 Jul 2016 11:05:26 GMT

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

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

Re: Chart total cell background

nareshthavidishetty — Thu, 07 Jul 2016 11:33:34 GMT

Hi,

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

Re: Chart total cell background

Frank_Hartmann — Thu, 07 Jul 2016 11:38:26 GMT

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:

Re: Chart total cell background

nareshthavidishetty — Thu, 07 Jul 2016 11:48:46 GMT

Hi,

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

Thanks..

Re: Chart total cell background

Thu, 07 Jul 2016 11:59:45 GMT

Can you try below solution too:

Expand the plus sign of the expression and in the Background Color write "white()" (without quotes)

Thanks,

Singh

Re: Chart total cell background

nareshthavidishetty — Thu, 07 Jul 2016 12:35:45 GMT

Hi,

Tried but not working..

Thanks..

Re: Chart total cell background

sunny_talwar — Thu, 07 Jul 2016 12:41:48 GMT

Is providing a sample a possibility?