topic Re: Background Color in App Development

Background Color

Frédéricdh — Tue, 11 Jun 2024 09:12:37 GMT

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

See the image:

Re: Background Color

theoat — Tue, 11 Jun 2024 15:55:10 GMT

Hi

Can you give more information about the color expression used?

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

Re: Background Color

Frédéricdh — Wed, 12 Jun 2024 08:38:46 GMT

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

Re: Background Color

TauseefKhan — Wed, 12 Jun 2024 10:41:49 GMT

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

Re: Background Color

Frédéricdh — Thu, 13 Jun 2024 12:43:41 GMT

I don't really understand

Re: Background Color

TauseefKhan — Thu, 13 Jun 2024 12:49:54 GMT

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.

Re: Background Color

Frédéricdh — Thu, 13 Jun 2024 13:20:36 GMT

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.