topic Re: Font Heat Color of some text box in App Development

Font Heat Color of some text box

HAMID_AKBARI — Mon, 02 Jun 2025 06:11:20 GMT

There are certain amount of text box whicj represen count of Equipment in organization.These put in diffrent page location and the backgroun is an image map.

I want to change font color base on their count respect to total.from bigger much darker to smaller lighter.

also how can i change their font size respect their portion?

Re: Font Heat Color of some text box

-SW- — Mon, 02 Jun 2025 08:49:09 GMT

You can colour by expression, using the ARGB() function.

Thats (Addressable, Red, Green, Blue). So you can put the measure in the addressable section, and divide it by the Largest number, and multiply it by 255.

Re: Font Heat Color of some text box

HAMID_AKBARI — Mon, 02 Jun 2025 09:01:54 GMT

The company has 15 area and i created 15 text box that show the equipments installed there.

I have the total and every count but cant figured how to relate every text box data to maximum and spectrum font color with RGB

Re: Font Heat Color of some text box

-SW- — Mon, 02 Jun 2025 09:13:14 GMT

You can maybe put those 15 expressions into a variable, which then gives the output as the largest of those 15 values to be used in the ARGB()

Re: Font Heat Color of some text box

HAMID_AKBARI — Mon, 02 Jun 2025 16:07:52 GMT

for better understanding I've sent an example file.

thanks in advance.

Re: Font Heat Color of some text box

-SW- — Mon, 02 Jun 2025 18:46:38 GMT

it would be something like this:

ARGB(
(
count({<Loc={'area 1'} >} [Equipment Code])
/
Max(aggr(count([Equipment Code]),Loc))
)
*256,
RED(),
Green(),
Blue()
)

Re: Font Heat Color of some text box

HAMID_AKBARI — Tue, 03 Jun 2025 08:28:06 GMT

Excellent.Best solution.Thanks

Re: Font Heat Color of some text box

HAMID_AKBARI — Tue, 03 Jun 2025 08:52:58 GMT

I searched about the dynamicfont size and i know its not formulable by the way is it possible to do the same for font size?

Re: Font Heat Color of some text box

-SW- — Tue, 03 Jun 2025 08:56:55 GMT

Unfortunately, its only a dropdown select in Qlikview