Refer Calculated Dimension Value for Color Expression Qlik Sense Pie Chart

[rpavan17]

Hi,

Can i get help  to Refer Calculated Dimension Value for Color Expression Qlik Sense Pie Chart.

=if(Status_Name='Inflow',(IF(Workflow_Age1 >= 0 and Workflow_Age1 <= 3, '0-3 Days',

IF(Workflow_Age1 >=4 and Workflow_Age1 <= 6, '4-6 Days',

IF(Workflow_Age1 >=7 and Workflow_Age1 <= 9, '7-9 Days',

IF(Workflow_Age1 > 9,  '>=10 Days' )) ) )))

I would like to have if Dimension Value = '0-3 Days' then green color... etc..,

Thanks

[agigliotti]

what about this in color expression:

=if( Status_Name = 'Inflow' and ( Workflow_Age1 >= 0 and Workflow_Age1 <= 3 ), green(),

and so on...

[priyalvp24]

Use peek & match function.

[rpavan17]

Could you please post the formula using this

[priyalvp24]

=IF(Workflow_Age1 >= 0 and Workflow_Age1 <= 3,

pick(match(Status_Name ,'Inflow' ),green()) and so on...

[rpavan17]

Color not changed using this

[priyalvp24]

You have to use Status_Name as pie chart dimension

[ChennaiahNallani]

in Script table:

IF(Workflow_Age1 >= 0 and Workflow_Age1 <= 3, '0-3 Days',

IF(Workflow_Age1 >=4 and Workflow_Age1 <= 6, '4-6 Days',

IF(Workflow_Age1 >=7 and Workflow_Age1 <= 9, '7-9 Days',

IF(Workflow_Age1 > 9,  '>=10 Days' )) ) ) as Workflow_Age_Days

=if(Status_Name='Inflow',Workflow_Age_Days)

Create Master Dimension with Workflow_Age_Days field and use visual color like below exp..

Drag master dimension field in your chart.