topic Re: Set analysis - Background color issues in App Development

Set analysis - Background color issues

lavanya_gurrapu — Tue, 12 Nov 2019 15:17:33 GMT

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

Re: Set analysis - Background color issues

lavanya_gurrapu — Wed, 13 Nov 2019 06:44:16 GMT

Can any one provide answer. This is bit urgent/

Re: Set analysis - Background color issues

Gopinathan — Wed, 13 Nov 2019 08:09:52 GMT

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

Re: Set analysis - Background color issues

lavanya_gurrapu — Wed, 13 Nov 2019 08:52:30 GMT

Hi Gopinathan,

Thanks alot for your quick help. It works perfectly.