topic Sunday Challenge: Dimension colour with 'floating' dimension in QlikView https://community.qlik.com/t5/QlikView/Sunday-Challenge-Dimension-colour-with-floating-dimension/m-p/562012#M209739 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>We're analyzing two sets of the same data using a floating dimension sort of thing (works really well for us).</P><P>This way we can select two sets of the 'same' dimension and perform a comparison. The detail of this isn't really in the attached document, but the relevant bits are.</P><P></P><P>However I would like to be able to colour the dimension backgrounds in the table to highlight which 'set' the dimension belongs to e.g.</P><P></P><P>trust A = green</P><P>trust B = red</P><P>anything else = yellow</P><P></P><P>Plus then the bubbles in the scatter chart to be the same</P><P></P><P>I've tried various formula to get it to work, obviously colouring for TrustA when there is just one selection is easy, but I can't wrap my head around what would work.</P><P></P><P>Note that our dimensions are not just as straight forward as a-f so hard-coding their values into a formula must be avoided if possible!!</P></BODY></HTML> Sun, 03 Nov 2013 20:57:09 GMT adamdavi3s 2013-11-03T20:57:09Z Sunday Challenge: Dimension colour with 'floating' dimension https://community.qlik.com/t5/QlikView/Sunday-Challenge-Dimension-colour-with-floating-dimension/m-p/562012#M209739 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>We're analyzing two sets of the same data using a floating dimension sort of thing (works really well for us).</P><P>This way we can select two sets of the 'same' dimension and perform a comparison. The detail of this isn't really in the attached document, but the relevant bits are.</P><P></P><P>However I would like to be able to colour the dimension backgrounds in the table to highlight which 'set' the dimension belongs to e.g.</P><P></P><P>trust A = green</P><P>trust B = red</P><P>anything else = yellow</P><P></P><P>Plus then the bubbles in the scatter chart to be the same</P><P></P><P>I've tried various formula to get it to work, obviously colouring for TrustA when there is just one selection is easy, but I can't wrap my head around what would work.</P><P></P><P>Note that our dimensions are not just as straight forward as a-f so hard-coding their values into a formula must be avoided if possible!!</P></BODY></HTML> Sun, 03 Nov 2013 20:57:09 GMT https://community.qlik.com/t5/QlikView/Sunday-Challenge-Dimension-colour-with-floating-dimension/m-p/562012#M209739 adamdavi3s 2013-11-03T20:57:09Z Re: Sunday Challenge: Dimension colour with 'floating' dimension https://community.qlik.com/t5/QlikView/Sunday-Challenge-Dimension-colour-with-floating-dimension/m-p/562013#M209740 <HTML><HEAD></HEAD><BODY><P>Maybe like this?</P></BODY></HTML> Sun, 03 Nov 2013 22:49:10 GMT https://community.qlik.com/t5/QlikView/Sunday-Challenge-Dimension-colour-with-floating-dimension/m-p/562013#M209740 swuehl 2013-11-03T22:49:10Z Re: Sunday Challenge: Dimension colour with 'floating' dimension https://community.qlik.com/t5/QlikView/Sunday-Challenge-Dimension-colour-with-floating-dimension/m-p/562014#M209741 <HTML><HEAD></HEAD><BODY><P>Here is one way...</P></BODY></HTML> Sun, 03 Nov 2013 23:13:47 GMT https://community.qlik.com/t5/QlikView/Sunday-Challenge-Dimension-colour-with-floating-dimension/m-p/562014#M209741 2013-11-03T23:13:47Z Re: Sunday Challenge: Dimension colour with 'floating' dimension https://community.qlik.com/t5/QlikView/Sunday-Challenge-Dimension-colour-with-floating-dimension/m-p/562015#M209742 <HTML><HEAD></HEAD><BODY><P>Thank you both!!</P><P></P><P>I'm going with the match formula as that is the one I am used to, can't believe I didn't think of that!</P><P></P><P>Thank you once again <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 04 Nov 2013 07:35:32 GMT https://community.qlik.com/t5/QlikView/Sunday-Challenge-Dimension-colour-with-floating-dimension/m-p/562015#M209742 adamdavi3s 2013-11-04T07:35:32Z