topic Re: Pivot table with a traffic light field in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-with-a-traffic-light-field/m-p/1006695#M974349 <HTML><HEAD></HEAD><BODY><P>Vikas, thank you very much for your help.</P></BODY></HTML> Thu, 10 Sep 2015 16:04:36 GMT Anonymous 2015-09-10T16:04:36Z Pivot table with a traffic light field https://community.qlik.com/t5/QlikView/Pivot-table-with-a-traffic-light-field/m-p/1006691#M974345 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I have a table as shown below, where a I need to add a colored column according to "SEMAFORO_ALIANZAET" value. For example, if the value is "2. PRÓXIMO A VENCERSE"&nbsp; the new field must be yellow colored and so on.</P><P>I will appreciate your help.</P><P></P><P><IMG alt="pivot_table_traffic_light.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/98425_pivot_table_traffic_light.JPG" style="height: auto;" /></P></BODY></HTML> Wed, 09 Sep 2015 17:14:53 GMT https://community.qlik.com/t5/QlikView/Pivot-table-with-a-traffic-light-field/m-p/1006691#M974345 Anonymous 2015-09-09T17:14:53Z Re: Pivot table with a traffic light field https://community.qlik.com/t5/QlikView/Pivot-table-with-a-traffic-light-field/m-p/1006692#M974346 <HTML><HEAD></HEAD><BODY><P>Have you tried using the Dimension background color using a condition. Given below is an example.</P><P><IMG alt="T179863.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/98395_T179863.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 09 Sep 2015 17:44:18 GMT https://community.qlik.com/t5/QlikView/Pivot-table-with-a-traffic-light-field/m-p/1006692#M974346 sudeepkm 2015-09-09T17:44:18Z Re: Pivot table with a traffic light field https://community.qlik.com/t5/QlikView/Pivot-table-with-a-traffic-light-field/m-p/1006693#M974347 <HTML><HEAD></HEAD><BODY><P>Sudeep, thank you very much for your answer. In your example, in the case DENMARK needs to be red colored and FRANCE blue, how would be the expression?</P></BODY></HTML> Wed, 09 Sep 2015 19:25:29 GMT https://community.qlik.com/t5/QlikView/Pivot-table-with-a-traffic-light-field/m-p/1006693#M974347 Anonymous 2015-09-09T19:25:29Z Re: Pivot table with a traffic light field https://community.qlik.com/t5/QlikView/Pivot-table-with-a-traffic-light-field/m-p/1006694#M974348 <HTML><HEAD></HEAD><BODY><P>PFA sample application</P><P></P><P>vikas</P></BODY></HTML> Thu, 10 Sep 2015 05:31:31 GMT https://community.qlik.com/t5/QlikView/Pivot-table-with-a-traffic-light-field/m-p/1006694#M974348 vikasmahajan 2015-09-10T05:31:31Z Re: Pivot table with a traffic light field https://community.qlik.com/t5/QlikView/Pivot-table-with-a-traffic-light-field/m-p/1006695#M974349 <HTML><HEAD></HEAD><BODY><P>Vikas, thank you very much for your help.</P></BODY></HTML> Thu, 10 Sep 2015 16:04:36 GMT https://community.qlik.com/t5/QlikView/Pivot-table-with-a-traffic-light-field/m-p/1006695#M974349 Anonymous 2015-09-10T16:04:36Z Re: Pivot table with a traffic light field https://community.qlik.com/t5/QlikView/Pivot-table-with-a-traffic-light-field/m-p/1006696#M974350 <HTML><HEAD></HEAD><BODY><P>Welcome</P></BODY></HTML> Fri, 11 Sep 2015 04:37:28 GMT https://community.qlik.com/t5/QlikView/Pivot-table-with-a-traffic-light-field/m-p/1006696#M974350 vikasmahajan 2015-09-11T04:37:28Z Re: Pivot table with a traffic light field https://community.qlik.com/t5/QlikView/Pivot-table-with-a-traffic-light-field/m-p/1006697#M974351 <HTML><HEAD></HEAD><BODY><P>any chance this could be in QVF</P></BODY></HTML> Thu, 03 Nov 2016 18:56:44 GMT https://community.qlik.com/t5/QlikView/Pivot-table-with-a-traffic-light-field/m-p/1006697#M974351 2016-11-03T18:56:44Z