If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Problem Using Conditional Palette with two measures

Started by shukscog, 31 Jul 2013 09:04:33 AM

Previous topic - Next topic

shukscog

Dear Friends,
Need your guidance to implement conditional palette on a bar chart as per the following scenario.
So I have a year data item with two values - 2013, 2014
I have two measures  -  Measure A, Measure B
I have another data item on X axis - ABC
So I am displaying the series as -
2013 Measure A, 2013 Measure B, 2014 Measure A, 2014 Measure B. Now I want to fix colors for all these 4 bars.
In the variable that I am using here , I am able to include and conditionally check the year. So for example -
case
when year = 2013 then green
else blue
But how to include the condition in the variable where I want to determine which measure is being used . So for example

Case
when (year = 2013 and Measure A or something) then green
when ( year = 2013 and Measure B or something) then yellow
when (year = 2014 and Measure A or something) then blue
when (year = 2014 and Measure B or something) then red
else none
end
So where I say "Measure A or something" can you please suggest a code or an alternate solution ?
Would be eternally grateful :)
Regards
Shuks