Color by Expression - Line Chart and Pie Chart

[hlines_usacs]

Hello,

I have a line chart and a bar chart in which I want to use the same expression to color.

Below is the expression and a screen shot of the two charts.

Is there a reason that they pie chart colors wouldn't work?

IF([Code] = '91'

,red()

    ,IF ([Code] = '83'

    ,blue()

        ,If(

 = '84'

            ,yellow()

        ,green()

                )

        )

   )

[pradosh_thakur]

please try the same expression  in the background color of the measure. it should work. for me its working.

[hlines_usacs]

Does Qlik Sense have "background colors of measures?"

[shraddha_g]

Background color of measure is available in Table

[ishanbhatt]

Hi,

Might be this is possible because you match the values as a string. You wrote the values in a single quote. Remove that quote and it'll work for you.

F([Code] = 91

,red()

    ,IF ([Code] = 83

    ,blue()

        ,If(

 = 84

            ,yellow()

        ,green()

                )

        )

   )

Also, See the Code values which you compare.

Thanks,

Ishan

[hlines_usacs]

That field is a string field. Some of the values in that field have letters. The ones I am displaying do not, but other values do.

With that, I have tried both ways (with single quotes and without them) multiple times.

[shraddha_g]

try instead of '='

use wildmatch() everywhere.

For ex:

IF(wildmatch([Code] ,'91'),

,red()

    ,IF (wildmatch([Code], 83),

    ,blue()

        ,If(wildmatch(

, 84),

            ,yellow()

        ,green()

                )

        )

   )