Font Heat Color of some text box

[HAMID_AKBARI]

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?

[-SW-]

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.

[HAMID_AKBARI]

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

[-SW-]

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()

[HAMID_AKBARI]

for better understanding I've sent an example file.

thanks in advance.

[-SW- · Accepted solution]

it would be something like this:

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

[HAMID_AKBARI]

Excellent.Best solution.Thanks

[HAMID_AKBARI]

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?

[-SW-]

Unfortunately, its only a dropdown select in Qlikview