Color By Expression for one dimension

[acrodrigues03]

Hi All!

I have a pie chart only with one dimension that is:

=IF([Channel]='A','1',

IF([Channel]='B' or

[Channel]= 'C' or

[Channel]='D' ,

'2',

IF([Channel]='E' or

[Channel]= 'F' or

[Channel]='G' ,

'3',)))

So my pie chart has 3 sections: 1,2 and 3.

I want to define the colors for each section. How can I do that?

Thank you in advance!

Carina

[acrodrigues03]

I need to do this with set analysis

[Anonymous]

You could create a Master Item using your Channel dimension and assigned colours to values :

https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/Colors/assigning-colors-to-di...

[acrodrigues03]

Hi Bill!

Thank you for your fast response! Unfortunately I need to define them outside of the master items with set analysis

[Anonymous]

In the properties panel go to:

• Appearance
• Colors abnd legengen
• Colors:  Customs & By expression
• For Expression

Use an expression something like

if ( equipment_owner = 'Leased' , green() , yellow() )

You can use whatever expression suits your needs.

[lcontezini]

Create the dimension in your script, then you colour your graph by expression, using the new dimension, like:

if(new_dimension=1,blue(),

if(new_dimension=2,green(),red()))