https://community.qlik.com/t5/Qlik-Sense-Documents/Qlik-Sense-App-iColor-Color-variables-generated-from-excel-tips/ta-p/1821232 <P>I client recently requested me to align the colors used in all their apps' objects to their corporate colors</P><P>To avoid having to edit each app again in the future if the color requirements change, I decided to create a method to populate the color variables from excel, thus next time I simply have to update the color codes in the excel file</P><P>To scale this approach out to other future implementations, I have created the attached .qvf file and excel files.</P><P>The app also includes examples of how to incorporate colors using certain functions / methods:</P><P>- ColorMix()</P><P>- Data Brushing</P><P>- Pick()</P><P>- Pick(Match())</P><P>I also included my list of useful color related websites to help you with color selection and design</P><P>Hope this will be useful to you <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Tue, 27 Jul 2021 02:23:30 GMT qlikconsult 2021-07-27T02:23:30Z https://community.qlik.com/t5/Qlik-Sense-Documents/Qlik-Sense-App-iColor-Color-variables-generated-from-excel-tips/ta-p/1821232 <P>Yes, yet another color app, BUT</P> Tue, 27 Jul 2021 02:23:30 GMT https://community.qlik.com/t5/Qlik-Sense-Documents/Qlik-Sense-App-iColor-Color-variables-generated-from-excel-tips/ta-p/1821232 qlikconsult 2021-07-27T02:23:30Z