Set analysis - Background color issues

[lavanya_gurrapu]

Hi,

I am facing very weird issue in qlik sense. I have created Pie chart using status. Total 7 status are available with the data. 

Used Set analysis for the measure of pie chart

Count({<[A],[B]>}([Status])) - Pie chart looks perfect and not changed even A,B Selected

The issue is with the background color. Without set analysis the color combination worked perfectly.

IF([Status]='A1,RGB(228,108,10),
IF([Status]='A2',RGB(255,192,0),
IF([Status]='A3',RGB(195,214,155),
IF([Status]='A4',RGB(0,204,0),
IF([Status]='A5',RGB(0,0,0),
IF([Status]='A6',RGB(79,129,189),
IF([Status]='A6',RGB(146,208,80),
IF([Status]='A7',RGB(176,175,174)))))))))

After set analysis, colors are not displayed properly. Few of the colors are grayed out. when i select 'A', few colors are grayed out. When i select 'B', all the colors are grayedout.

Is there any thing i need to do stay background color for set analysis.

Please help.

Appreciate for quick response

[lavanya_gurrapu]

Can any one provide answer. This is bit urgent/

[Gopinathan · Accepted solution]

Try like,

IF(Count({1<[Status]={'A1'}>}([Status]))>0,RGB(228,108,10),
IF(Count({1<[Status]={'A2'}>}([Status]))>0,RGB(255,192,0),
IF(Count({1<[Status]={'A3'}>}([Status]))>0,RGB(195,214,155),
IF(Count({1<[Status]={'A4'}>}([Status]))>0,RGB(0,204,0),
IF(Count({1<[Status]={'A5'}>}([Status]))>0,RGB(0,0,0),
IF(Count({1<[Status]={'A6'}>}([Status]))>0,RGB(79,129,189), //// both are A6 on your post
IF(Count({1<[Status]={'A6'}>}([Status]))>0,RGB(146,208,80), //// both are A6 on your post
IF(Count({1<[Status]={'A7'}>}([Status]))>0,RGB(176,175,174)))))))))

[lavanya_gurrapu]

Hi Gopinathan,

Thanks alot for your quick help. It works perfectly.