<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Bar Plus Color Expression in Integration, Extension &amp; APIs</title>
    <link>https://community.qlik.com/t5/Integration-Extension-APIs/Bar-Plus-Color-Expression/m-p/17369#M264</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi All&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I am trying to implement the &lt;STRONG&gt;Bar Plus &lt;/STRONG&gt;extension &lt;STRONG style="font-size: 13.3333px;"&gt;&lt;A href="http://branch.qlik.com/#!/project/5858f900c0568806cf368930" title="http://branch.qlik.com/#!/project/5858f900c0568806cf368930"&gt;Qlik Branch&lt;/A&gt;&lt;/STRONG&gt; in my application because my requirement is to display the individual values on the stacked bar but &lt;STRONG&gt;I cannot set the color expression to my chart.&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Can anyone please help me with the solution?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The color expression I am using is mentioned below:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;if(NewDays_Bucket = '0-90', rgb(216,191,216),&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;if(NewDays_Bucket = '90-180', rgb(186,85,211),&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;if(NewDays_Bucket = '180-365', rgb(255,185,92),&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;if(NewDays_Bucket = 'Above 365',rgb(255,99,71)))))&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;&lt;BR /&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;&lt;IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/200781_Capture.PNG" style="height: 156px; width: 620px;" /&gt;&lt;BR /&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;where NewDays_Bucket is my Dimension and I am using 2 dimensions:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;1. Department Name&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;2. &lt;/STRONG&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;&lt;STRONG&gt;NewDays_Bucket&lt;/STRONG&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 25 Apr 2018 13:55:01 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2018-04-25T13:55:01Z</dc:date>
    <item>
      <title>Bar Plus Color Expression</title>
      <link>https://community.qlik.com/t5/Integration-Extension-APIs/Bar-Plus-Color-Expression/m-p/17369#M264</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi All&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I am trying to implement the &lt;STRONG&gt;Bar Plus &lt;/STRONG&gt;extension &lt;STRONG style="font-size: 13.3333px;"&gt;&lt;A href="http://branch.qlik.com/#!/project/5858f900c0568806cf368930" title="http://branch.qlik.com/#!/project/5858f900c0568806cf368930"&gt;Qlik Branch&lt;/A&gt;&lt;/STRONG&gt; in my application because my requirement is to display the individual values on the stacked bar but &lt;STRONG&gt;I cannot set the color expression to my chart.&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Can anyone please help me with the solution?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The color expression I am using is mentioned below:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;if(NewDays_Bucket = '0-90', rgb(216,191,216),&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;if(NewDays_Bucket = '90-180', rgb(186,85,211),&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;if(NewDays_Bucket = '180-365', rgb(255,185,92),&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;if(NewDays_Bucket = 'Above 365',rgb(255,99,71)))))&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;&lt;BR /&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;&lt;IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/200781_Capture.PNG" style="height: 156px; width: 620px;" /&gt;&lt;BR /&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;where NewDays_Bucket is my Dimension and I am using 2 dimensions:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;1. Department Name&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;2. &lt;/STRONG&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;&lt;STRONG&gt;NewDays_Bucket&lt;/STRONG&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 25 Apr 2018 13:55:01 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Integration-Extension-APIs/Bar-Plus-Color-Expression/m-p/17369#M264</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2018-04-25T13:55:01Z</dc:date>
    </item>
    <item>
      <title>Re: Bar Plus Color Expression</title>
      <link>https://community.qlik.com/t5/Integration-Extension-APIs/Bar-Plus-Color-Expression/m-p/1581461#M10568</link>
      <description>&lt;P&gt;Go in your dimension options and put your color expression formular in "Dimension attribute" where you have added your dimension&amp;nbsp;&lt;STRONG&gt;NewDays_Bucket&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;Then go in the options for "Colors and Legend" and set the color source to "Calculated" and set the color attribute to "Attribute is color value".&lt;/P&gt;&lt;P&gt;It's actually very well documented at&amp;nbsp;&lt;A href="https://developer.qlik.com/garden/5858f900c0568806cf368930" target="_blank"&gt;https://developer.qlik.com/garden/5858f900c0568806cf368930&lt;/A&gt;&lt;/P&gt;&lt;P&gt;Just scroll down to the chapter "Calculated Colors".&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Fri, 17 May 2019 09:21:18 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Integration-Extension-APIs/Bar-Plus-Color-Expression/m-p/1581461#M10568</guid>
      <dc:creator>Kazuma</dc:creator>
      <dc:date>2019-05-17T09:21:18Z</dc:date>
    </item>
  </channel>
</rss>

