Pie Chart - Fixed Color Scheme

[#1]

Hi All,

Ive a requirement to show the number of inprogress projects for the latest month available in the data set in a Pie chart with fixed color scheme. So in this process pie chart should not respond to the selections made in time list boxes(fiscal year, month,year) but should be sensitive to other parameters like project manager & leader.

So Ive used variancegroup as dimension and used set analysis on the metric

count({$<[PCD Fiscal Year]=,[PCD Fiscal Quarter]=,[PCD Month Abbr]=,[PCD LatestMonthFlag]={1},[Inprogressflag]={1}>} [VarianceGroup])

and hardcoded the color scheme in the "background color" definition of the Metric based on the variancegroup name as shown below.

if([VarianceGroup] = 'Ontime',RGB(0,255,0),

if([VarianceGroup] = '1-30Days',RGB(255,255,0),

if([VarianceGroup] = '31+Days',RGB(255,0,0))))

Looks like metric expression is working as expected (showing the latest month values even after selecting the time bound parameters). But color scheme is not working. If I select the  year - 2013 then 2 groups are with color scheme - Black and one group is working as expected. I know why its showing it as BLACK but not able to come up with a solution.

I am attaching the solution file .Can some one help.

thanks

Chandra

[Anonymous]

Hi,

Simply use color from color tab with persistent option. This will help you. Creating color logic based on column may not work if the column is not associated with selection.

[preminqlik · Accepted solution]

try with this exp

=alt(only({<[VarianceGroup] = {'Ontime'},[PCD Fiscal Year]=,[PCD Fiscal Quarter]=,[PCD Month Abbr]=,[PCD LatestMonthFlag]={1},[Inprogressflag]={1} >}RGB(0,255,0)),

only({<[VarianceGroup] = {'1-30Days'},[PCD Fiscal Year]=,[PCD Fiscal Quarter]=,[PCD Month Abbr]=,[PCD LatestMonthFlag]={1},[Inprogressflag]={1}  >}RGB(255,255,0)),

only({<[VarianceGroup] = {'31+Days' },[PCD Fiscal Year]=,[PCD Fiscal Quarter]=,[PCD Month Abbr]=,[PCD LatestMonthFlag]={1},[Inprogressflag]={1}  >}RGB(255,0,0)))

i have attached your app with above exp ..look into that ! hope this helps yu...

[#4]

Prem,

This worked like a charm. Thank you for the quick response.

Thanks

Chandra