topic Re: Colour formating in Pivot table in QlikView https://community.qlik.com/t5/QlikView/Colour-formating-in-Pivot-table/m-p/991173#M528619 <HTML><HEAD></HEAD><BODY><P>I send you and example</P></BODY></HTML> Mon, 07 Sep 2015 16:34:28 GMT ecolomer 2015-09-07T16:34:28Z Colour formating in Pivot table https://community.qlik.com/t5/QlikView/Colour-formating-in-Pivot-table/m-p/991168#M528614 <HTML><HEAD></HEAD><BODY><P>Hello I have a pivot table which takes data from a table which has a field which holds the colour in the form of "red()".</P><P></P><P>I think there is a bug when 1 row has 2 values and in a pivot table the two cells are merged. Colour option doesn't not work well on merged cell? Does some one have a solution? Attached demo app.</P><P></P><P>Thank you,</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/98221_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Mon, 07 Sep 2015 16:11:35 GMT https://community.qlik.com/t5/QlikView/Colour-formating-in-Pivot-table/m-p/991168#M528614 2015-09-07T16:11:35Z Re: Colour formating in Pivot table https://community.qlik.com/t5/QlikView/Colour-formating-in-Pivot-table/m-p/991169#M528615 <HTML><HEAD></HEAD><BODY><P>Is that ??</P><P><IMG alt="p53.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/98228_p53.png" style="height: 331px; width: 620px;" /></P></BODY></HTML> Mon, 07 Sep 2015 16:17:24 GMT https://community.qlik.com/t5/QlikView/Colour-formating-in-Pivot-table/m-p/991169#M528615 ecolomer 2015-09-07T16:17:24Z Re: Colour formating in Pivot table https://community.qlik.com/t5/QlikView/Colour-formating-in-Pivot-table/m-p/991170#M528616 <HTML><HEAD></HEAD><BODY><P>I wanted to do it for the dimension, but I copied the formula that you suggested for the expression it worked!!</P><P></P><P>Thank you!</P></BODY></HTML> Mon, 07 Sep 2015 16:21:20 GMT https://community.qlik.com/t5/QlikView/Colour-formating-in-Pivot-table/m-p/991170#M528616 2015-09-07T16:21:20Z Re: Colour formating in Pivot table https://community.qlik.com/t5/QlikView/Colour-formating-in-Pivot-table/m-p/991171#M528617 <HTML><HEAD></HEAD><BODY><P>Do you think it's possible to have this colour coding without an expression? as I have added a dummy sum(1) only so that the colouring works. As without the expression the colouring deosnt work ...</P></BODY></HTML> Mon, 07 Sep 2015 16:26:31 GMT https://community.qlik.com/t5/QlikView/Colour-formating-in-Pivot-table/m-p/991171#M528617 2015-09-07T16:26:31Z Re: Colour formating in Pivot table https://community.qlik.com/t5/QlikView/Colour-formating-in-Pivot-table/m-p/991172#M528618 <HTML><HEAD></HEAD><BODY><P>Yes you can use an expression in the Background color and also in the text color, in dimension and also in expressions</P></BODY></HTML> Mon, 07 Sep 2015 16:29:10 GMT https://community.qlik.com/t5/QlikView/Colour-formating-in-Pivot-table/m-p/991172#M528618 ecolomer 2015-09-07T16:29:10Z Re: Colour formating in Pivot table https://community.qlik.com/t5/QlikView/Colour-formating-in-Pivot-table/m-p/991173#M528619 <HTML><HEAD></HEAD><BODY><P>I send you and example</P></BODY></HTML> Mon, 07 Sep 2015 16:34:28 GMT https://community.qlik.com/t5/QlikView/Colour-formating-in-Pivot-table/m-p/991173#M528619 ecolomer 2015-09-07T16:34:28Z Re: Colour formating in Pivot table https://community.qlik.com/t5/QlikView/Colour-formating-in-Pivot-table/m-p/991174#M528620 <HTML><HEAD></HEAD><BODY><P>Very useful! Thank you!</P></BODY></HTML> Mon, 07 Sep 2015 16:40:14 GMT https://community.qlik.com/t5/QlikView/Colour-formating-in-Pivot-table/m-p/991174#M528620 2015-09-07T16:40:14Z