topic Re: Set analysis issue with coloring dimension in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-issue-with-coloring-dimension/m-p/1305765#M406480 <HTML><HEAD></HEAD><BODY><P>try this expression</P><P></P><P>=only({1}if(Project='Project4' or BusinessUnit = 'BU1', Rgb(106,168,79)))</P></BODY></HTML> Wed, 12 Apr 2017 10:47:55 GMT Kushal_Chawda 2017-04-12T10:47:55Z Set analysis issue with coloring dimension https://community.qlik.com/t5/QlikView/Set-analysis-issue-with-coloring-dimension/m-p/1305762#M406477 <HTML><HEAD></HEAD><BODY><P>Hello all, I would like to ask you for your help with coloring and set analysis.</P><P>Issue that I am having (please take a look on the file that I am attaching) is the when set analysis is used (second expression) coloring is not working. When you select let’s say April as month, you can see that Business unit column is not colored green. When nothing is selected Business unit is colored. What I need is that regardless what is selected, those rows should be colored by a condition specified in Background Color option. So even though regular expression is showing 0, coloring of first dimension should be implemented</P><P></P><P>Thank you in advance</P></BODY></HTML> Wed, 12 Apr 2017 10:21:13 GMT https://community.qlik.com/t5/QlikView/Set-analysis-issue-with-coloring-dimension/m-p/1305762#M406477 2017-04-12T10:21:13Z Re: Set analysis issue with coloring dimension https://community.qlik.com/t5/QlikView/Set-analysis-issue-with-coloring-dimension/m-p/1305763#M406478 <HTML><HEAD></HEAD><BODY><P>Is your condition is correct, =if(Project='Project4' or BusinessUnit = 'BU1', Rgb(106,168,79))</P><P></P><P>If condition correct then output giving exactly as per condition</P></BODY></HTML> Wed, 12 Apr 2017 10:29:33 GMT https://community.qlik.com/t5/QlikView/Set-analysis-issue-with-coloring-dimension/m-p/1305763#M406478 Anil_Babu_Samineni 2017-04-12T10:29:33Z Re: Set analysis issue with coloring dimension https://community.qlik.com/t5/QlikView/Set-analysis-issue-with-coloring-dimension/m-p/1305764#M406479 <HTML><HEAD></HEAD><BODY><P>hi</P><P>use this expression</P><P>=if(only({1}Project)='Project4' or only({1}BusinessUnit) = 'BU1', Rgb(106,168,79))</P><P></P><P>also have a look at the attach file</P></BODY></HTML> Wed, 12 Apr 2017 10:44:55 GMT https://community.qlik.com/t5/QlikView/Set-analysis-issue-with-coloring-dimension/m-p/1305764#M406479 lironbaram 2017-04-12T10:44:55Z Re: Set analysis issue with coloring dimension https://community.qlik.com/t5/QlikView/Set-analysis-issue-with-coloring-dimension/m-p/1305765#M406480 <HTML><HEAD></HEAD><BODY><P>try this expression</P><P></P><P>=only({1}if(Project='Project4' or BusinessUnit = 'BU1', Rgb(106,168,79)))</P></BODY></HTML> Wed, 12 Apr 2017 10:47:55 GMT https://community.qlik.com/t5/QlikView/Set-analysis-issue-with-coloring-dimension/m-p/1305765#M406480 Kushal_Chawda 2017-04-12T10:47:55Z