https://community.qlik.com/t5/App-Development/Assigned-colour-in-multi-dimension-histogram-chart/m-p/2006326#M83277 <P>Hi, in the app I'm developing, I have a histogram chart with two dimensions (one dimension which is a column of a table and another which is a drill down of several columns of the same table). In the "colour source" section I have inserted the formula to assign colors to pillars. However the colors of the columns are different from the RGB set.&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Roberto03_0-1668762905592.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/94066i5E380B30FE3C60B3/image-size/medium?v=v2&amp;px=400" role="button" title="Roberto03_0-1668762905592.png" alt="Roberto03_0-1668762905592.png" /></span></P> <P>The formula works well in pie chart bur not in that type of chart.</P> <P>the formula is&nbsp;=pick(wildmatch([TABLE FIELD],'GPL', 'ELETTRICITÀ', 'Gasolio', 'Metano - Carbone','pellet+pula+legna','SOLARE TERMICO/ FOTOVOLTAICO','*'),<BR />RGB(255,165,0), RGB(171,205,239), RGB(112,128,144), RGB(123,160,91), RGB(152,118,84), RGB(255,216,0), RGB(0,0,0))</P> <P>thanks.</P> Fri, 18 Nov 2022 09:18:34 GMT Roberto03 2022-11-18T09:18:34Z https://community.qlik.com/t5/App-Development/Assigned-colour-in-multi-dimension-histogram-chart/m-p/2006326#M83277 <P>Hi, in the app I'm developing, I have a histogram chart with two dimensions (one dimension which is a column of a table and another which is a drill down of several columns of the same table). In the "colour source" section I have inserted the formula to assign colors to pillars. However the colors of the columns are different from the RGB set.&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Roberto03_0-1668762905592.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/94066i5E380B30FE3C60B3/image-size/medium?v=v2&amp;px=400" role="button" title="Roberto03_0-1668762905592.png" alt="Roberto03_0-1668762905592.png" /></span></P> <P>The formula works well in pie chart bur not in that type of chart.</P> <P>the formula is&nbsp;=pick(wildmatch([TABLE FIELD],'GPL', 'ELETTRICITÀ', 'Gasolio', 'Metano - Carbone','pellet+pula+legna','SOLARE TERMICO/ FOTOVOLTAICO','*'),<BR />RGB(255,165,0), RGB(171,205,239), RGB(112,128,144), RGB(123,160,91), RGB(152,118,84), RGB(255,216,0), RGB(0,0,0))</P> <P>thanks.</P> Fri, 18 Nov 2022 09:18:34 GMT https://community.qlik.com/t5/App-Development/Assigned-colour-in-multi-dimension-histogram-chart/m-p/2006326#M83277 Roberto03 2022-11-18T09:18:34Z https://community.qlik.com/t5/App-Development/Assigned-colour-in-multi-dimension-histogram-chart/m-p/2006904#M83315 <P>Hi, maybe this video can helps you<BR /><div class="video-embed-center video-embed"><iframe class="embedly-embed" src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2Fu9Z1_QRTG04%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Du9Z1_QRTG04&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2Fu9Z1_QRTG04%2Fhqdefault.jpg&amp;type=text%2Fhtml&amp;schema=youtube" width="400" height="225" scrolling="no" title="Coloring visualizations using expressions - Qlik Sense" frameborder="0" allow="autoplay; fullscreen; encrypted-media; picture-in-picture;" allowfullscreen="true"></iframe></div></P> Mon, 21 Nov 2022 09:40:07 GMT https://community.qlik.com/t5/App-Development/Assigned-colour-in-multi-dimension-histogram-chart/m-p/2006904#M83315 GiuseppePanella_ 2022-11-21T09:40:07Z