topic Re: Pie Chart - Fixed Color Scheme in QlikView

Pie Chart - Fixed Color Scheme

Wed, 16 Jul 2014 03:51:30 GMT

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

Re: Pie Chart - Fixed Color Scheme

Anonymous — Wed, 16 Jul 2014 04:08:15 GMT

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.

Re: Pie Chart - Fixed Color Scheme

preminqlik — Wed, 16 Jul 2014 04:09:25 GMT

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...

Re: Pie Chart - Fixed Color Scheme

Wed, 16 Jul 2014 05:30:05 GMT

Prem,

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

Thanks

Chandra