Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
i have a problem with colour of text in chart expression, equals within info-expression:
for example:
tab1:
LOAD * inline
[field1
GOOD
UNDEF_01
UNDEF_02
UNDEF_03
UNDEF_04
UNDEF_05
UNDEF_06
UNDEF_07];
Info LOAD * inline
[field1,Color
GOOD, '0'
UNDEF_01,'10'
UNDEF_02,'20'
UNDEF_03,'30'
UNDEF_04,'40'
UNDEF_05,'50'
UNDEF_06,'60'
UNDEF_07,'70'];
I set TextColor=Color(Info(field1)) in chart expression, but it`s not working.
Who knows good way to this?
Thanks!
Info loads are for linking external information like documents or images.
What you want can be done
LOAD * inline
[field1,Color
GOOD, 0
UNDEF_01,10
UNDEF_02,20
UNDEF_03,30
UNDEF_04,40
UNDEF_05,50
UNDEF_06,60
UNDEF_07,70];
and set textcolor to color(Color), though you may want to use color(Color/10) instead since there's a limited number of predefined colors. Or the RGB function and fields for R,G and B values in your table.
Thanks, but this obvious solution did not suit me. Application has many big tables with similiar fields as field1. Joining to each similar field "color-field" will extra increase size of datamodel.
BTW, expression Info(field1) returns valid result (Color value).