Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

schtierlietz
New Contributor

TextColor as result of info-calculation.

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!

2 Replies

Re: TextColor as result of info-calculation.

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.


talk is cheap, supply exceeds demand
schtierlietz
New Contributor

Re: TextColor as result of info-calculation.

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

Community Browser