7 Replies Latest reply: Aug 21, 2018 7:36 AM by Chennaiah Nallani RSS

    Refer Calculated Dimension Value for Color Expression Qlik Sense Pie Chart

    Pavan R

      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