topic Re: Conditional background colors with set analysis in QlikView https://community.qlik.com/t5/QlikView/Conditional-background-colors-with-set-analysis/m-p/699115#M252392 <HTML><HEAD></HEAD><BODY><P>It worked!!!</P></BODY></HTML> Mon, 15 Sep 2014 13:04:38 GMT agomes1971 2014-09-15T13:04:38Z Conditional background colors with set analysis https://community.qlik.com/t5/QlikView/Conditional-background-colors-with-set-analysis/m-p/699112#M252389 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>is it possible to format background colors with set analysis associated to a listbox ?</P><P></P><P>Please see attached.</P><P></P><P>Thanks in advance</P></BODY></HTML> Mon, 15 Sep 2014 12:43:45 GMT https://community.qlik.com/t5/QlikView/Conditional-background-colors-with-set-analysis/m-p/699112#M252389 agomes1971 2014-09-15T12:43:45Z Re: Conditional background colors with set analysis https://community.qlik.com/t5/QlikView/Conditional-background-colors-with-set-analysis/m-p/699113#M252390 <HTML><HEAD></HEAD><BODY><P>Can you explain your requirement?</P></BODY></HTML> Mon, 15 Sep 2014 12:46:45 GMT https://community.qlik.com/t5/QlikView/Conditional-background-colors-with-set-analysis/m-p/699113#M252390 anbu1984 2014-09-15T12:46:45Z Re: Conditional background colors with set analysis https://community.qlik.com/t5/QlikView/Conditional-background-colors-with-set-analysis/m-p/699114#M252391 <HTML><HEAD></HEAD><BODY><P>I think you are trying to get all year bars to be the same color depending on the selection in a list box.</P><P></P><P>I put in some extra code that in a chart will be more explicit that only 1 Area be evaluated. Use this on the 'background color' expression to color all bars the same:</P><P></P><P>=If( only( TOTAL aggr(only( TOTAL Area),Year)) = 'Litros', RGB(75, 172, 198),If( only( TOTAL aggr(only( total Area),Year)) = 'Outras Vendas', RGB(146, 208, 80), RGB(255, 192, 0)))</P></BODY></HTML> Mon, 15 Sep 2014 13:00:27 GMT https://community.qlik.com/t5/QlikView/Conditional-background-colors-with-set-analysis/m-p/699114#M252391 JonnyPoole 2014-09-15T13:00:27Z Re: Conditional background colors with set analysis https://community.qlik.com/t5/QlikView/Conditional-background-colors-with-set-analysis/m-p/699115#M252392 <HTML><HEAD></HEAD><BODY><P>It worked!!!</P></BODY></HTML> Mon, 15 Sep 2014 13:04:38 GMT https://community.qlik.com/t5/QlikView/Conditional-background-colors-with-set-analysis/m-p/699115#M252392 agomes1971 2014-09-15T13:04:38Z