Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone, I have a question. I have a chart that depending the dimension Im showing it has its own unique set of colors. I was able to do this till two conditionals. Can someone please help to add a third one (Resources) when if its not one of the two conditionals that i have use the default set of qlik colors?
This is my expression that works perfect for two conditions:
=If(GetCurrentField(Forecast)='Area',(IF(Area='DRIVE',vAreaColorBlue,
IF(Area='FIN', vAreaColorlightblue,
IF(Area='GX', vAreaColorCelestial,
IF(Area='HBG', vAreaColorWhite,
IF(Area='N/A', vAreaColorBeige,
IF(Area='IT' , vAreaColorBeige,
IF(Area='OE & BD', vAreaColorLightGrey,
IF(Area='REGIONS', vAreaColorDarkGray,
IF(Area='S&M', vAreaColorBlack,
IF(Area='HR', vAreaColorSand,
vCorporateColor_Red ))))))))))),(IF(ACCOUNT_TYPE='Project',vCorporateColor_Blue,
IF(ACCOUNT_TYPE='Change Request', vCorporateColor_Green,
IF(ACCOUNT_TYPE='Incidents & Maintenance', vCorporateColor_Yellow,
IF(ACCOUNT_TYPE='Mgmt & Adm',vCorporateColor_Orange,
IF(ACCOUNT_TYPE='Project Proposal',vCorporateColor_Gray
,vCorporateColor_Red )))))))
I found out how to get the default set of colors with this Expression: If(GetCurrentField(Forecast)='Resources',''
But then again my problem its how to add this third conditional?
Thank you for your time,
Pablo
May be you need to simplify what you have today
=If(GetCurrentField(Forecast)='Area',
Pick(Match(Area, 'DRIVE', 'FIN', 'GX', 'HBG', 'N/A', 'IT', 'OE & BD', 'REGIONS', 'S&M', 'HR') + 1,
vCorporateColor_Red,
vAreaColorBlue,
vAreaColorlightblue,
vAreaColorCelestial,
vAreaColorWhite,
vAreaColorBeige,
vAreaColorBeige,
vAreaColorLightGrey,
vAreaColorBlack,
vAreaColorSand),
If(GetCurrentField(Forecast)='ACCOUNT_TYPE',
Pick(Match(ACCOUNT_TYPE, 'Project', 'Change Request', 'Incidents & Maintenance', 'Mgmt & Adm', 'Project Proposal') + 1
vCorporateColor_Red,
vCorporateColor_Blue,
vCorporateColor_Green,
vCorporateColor_Yellow,
vCorporateColor_Orange,
vCorporateColor_Gray),
If(GetCurrentField(Forecast) = 'Resources',
Pick(Match, ......) + 1
...
...
...))))
May be you need to simplify what you have today
=If(GetCurrentField(Forecast)='Area',
Pick(Match(Area, 'DRIVE', 'FIN', 'GX', 'HBG', 'N/A', 'IT', 'OE & BD', 'REGIONS', 'S&M', 'HR') + 1,
vCorporateColor_Red,
vAreaColorBlue,
vAreaColorlightblue,
vAreaColorCelestial,
vAreaColorWhite,
vAreaColorBeige,
vAreaColorBeige,
vAreaColorLightGrey,
vAreaColorBlack,
vAreaColorSand),
If(GetCurrentField(Forecast)='ACCOUNT_TYPE',
Pick(Match(ACCOUNT_TYPE, 'Project', 'Change Request', 'Incidents & Maintenance', 'Mgmt & Adm', 'Project Proposal') + 1
vCorporateColor_Red,
vCorporateColor_Blue,
vCorporateColor_Green,
vCorporateColor_Yellow,
vCorporateColor_Orange,
vCorporateColor_Gray),
If(GetCurrentField(Forecast) = 'Resources',
Pick(Match, ......) + 1
...
...
...))))
Thank you very much for your answer!