topic Defined list to defined color in QlikView https://community.qlik.com/t5/QlikView/Defined-list-to-defined-color/m-p/116162#M604687 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have a Excel with 2 sheet,</P><OL><LI>onewith a list of 20 car model name and it's sale, location of manufacturer.</LI><LI>Car model name with rbg </LI></OL><P></P><P>When loaded and creating graph, we need specific model name to have the rbg in the bar graph or pi chart.</P><P></P><P>Trying to use a variable to pick the list since if the Excel is modified with rbg will provide the changes.</P><P></P><P>PL help</P><P><A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌</P><P>Tony</P></BODY></HTML> Thu, 05 Jul 2018 19:46:55 GMT Anonymous 2018-07-05T19:46:55Z Defined list to defined color https://community.qlik.com/t5/QlikView/Defined-list-to-defined-color/m-p/116162#M604687 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have a Excel with 2 sheet,</P><OL><LI>onewith a list of 20 car model name and it's sale, location of manufacturer.</LI><LI>Car model name with rbg </LI></OL><P></P><P>When loaded and creating graph, we need specific model name to have the rbg in the bar graph or pi chart.</P><P></P><P>Trying to use a variable to pick the list since if the Excel is modified with rbg will provide the changes.</P><P></P><P>PL help</P><P><A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌</P><P>Tony</P></BODY></HTML> Thu, 05 Jul 2018 19:46:55 GMT https://community.qlik.com/t5/QlikView/Defined-list-to-defined-color/m-p/116162#M604687 Anonymous 2018-07-05T19:46:55Z Re: Defined list to defined color https://community.qlik.com/t5/QlikView/Defined-list-to-defined-color/m-p/116163#M604688 <HTML><HEAD></HEAD><BODY><P>why use a variable? use field with rgb as expression in your chart per car model</P></BODY></HTML> Thu, 05 Jul 2018 19:48:26 GMT https://community.qlik.com/t5/QlikView/Defined-list-to-defined-color/m-p/116163#M604688 mikaelsc 2018-07-05T19:48:26Z Re: Defined list to defined color https://community.qlik.com/t5/QlikView/Defined-list-to-defined-color/m-p/116164#M604689 <HTML><HEAD></HEAD><BODY><P>*as color expression</P></BODY></HTML> Thu, 05 Jul 2018 19:48:40 GMT https://community.qlik.com/t5/QlikView/Defined-list-to-defined-color/m-p/116164#M604689 mikaelsc 2018-07-05T19:48:40Z Re: Defined list to defined color https://community.qlik.com/t5/QlikView/Defined-list-to-defined-color/m-p/116165#M604690 <HTML><HEAD></HEAD><BODY><P>See if this approach suits your need</P><P><A href="http://www.learnallbi.com/maintaining-color-of-the-dimensions-in-qlikview/" title="http://www.learnallbi.com/maintaining-color-of-the-dimensions-in-qlikview/">Maintaining Color of the Dimensions in QlikView – Learn QlikView</A></P></BODY></HTML> Fri, 06 Jul 2018 12:10:32 GMT https://community.qlik.com/t5/QlikView/Defined-list-to-defined-color/m-p/116165#M604690 sunny_talwar 2018-07-06T12:10:32Z