Background Color

[Frédéricdh]

Why, when I tag the Option Suppress the Zero Value in Presentation, the background is not the same??

See the image:

[theoat]

Hi

Can you give more information about the color expression used?

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

[Frédéricdh]

The expression is like: Pick(Match(Only(<> ORT)))

[TauseefKhan]

Hi @Frédéricdh,

It can affect the background color because the cells with zero or null values are not displayed, and therefore, the background color expression may not be applied.

// Apply dynamic background coloring
LOAD *,
IF(
NOT IsNull(Only(ORT)) AND Only(ORT) <> 0,
Pick(
Match(Only(ORT), 10, 5, 15),
RGB(255,0,0), RGB(0,255,0), RGB(0,0,255)
),
RGB(200,200,200)
) AS BackgroundColor
RESIDENT YourTable;

Hope this resolve your issue.
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions").

[Frédéricdh]

I don't really understand

[TauseefKhan]

When you use the option to suppress zero values in the presentation of a table, it can affect the background color because the cells with zero or null values are not displayed, and therefore, the background color expression may not be applied to them.

To ensure that the background color is consistent, even for cells with zero or null values, you can modify your script to handle null values explicitly.

[Frédéricdh]

Sorry, I don't understand what you do.

why you make a load?

And the you test the value if it's a zero or not but the problem for me, is the background of the title, not the value of the title.