<?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 chart one bar stack and one not in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/bar-chart-one-bar-stack-and-one-not/m-p/1554580#M440567</link>
    <description>&lt;P&gt;hi,&lt;/P&gt;&lt;P&gt;i have a bar chart that i need in each month one bar need to be stacked and one&amp;nbsp; not stacked.&lt;/P&gt;&lt;P&gt;to do it im using a dimension called "_bar" with the values 1,2&lt;/P&gt;&lt;P&gt;_bar=1 its the stacked and 2 not stacked&lt;/P&gt;&lt;P&gt;i have 3 expressions ex1,2 go to _bar=1&lt;/P&gt;&lt;P&gt;and ex3 go to _bar=2.&lt;/P&gt;&lt;P&gt;its all work fine &lt;U&gt;but&lt;/U&gt; in need to have set analysis on the year end month selection/&lt;/P&gt;&lt;P&gt;i want to see the bar in all the months.&lt;/P&gt;&lt;P&gt;and the the condition with the _bar dont allow me to see it in all the month.&lt;/P&gt;&lt;P&gt;&amp;nbsp;i tried-&lt;/P&gt;&lt;P&gt;=if(only({&amp;lt;SAVE_MONTH={"&amp;gt;=$(vLastYearDate)&amp;lt;=$(vCurrYearDate)"},Year=,Month=,Quarter=&amp;gt;}_BAR)=1,&lt;BR /&gt;FABS(sum({&amp;lt;SAVE_MONTH={"&amp;gt;=$(vLastYearDate)&amp;lt;=$(vCurrYearDate)"},Year=,Month=,Quarter=,ST_TRANS_LOGIC={'Issue3'},DSLW_ORDER_TYPE={'slow to raw'}&amp;gt;}ST_VALUE_USD))/1000)&lt;/P&gt;&lt;P&gt;NOT WORKING...&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 796px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/7654i1A250F9F02BE1F54/image-size/large?v=v2&amp;amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;someone can help?&lt;/P&gt;&lt;P&gt;adi&lt;/P&gt;</description>
    <pubDate>Sun, 10 Mar 2019 07:18:26 GMT</pubDate>
    <dc:creator>adiarnon</dc:creator>
    <dc:date>2019-03-10T07:18:26Z</dc:date>
    <item>
      <title>bar chart one bar stack and one not</title>
      <link>https://community.qlik.com/t5/QlikView/bar-chart-one-bar-stack-and-one-not/m-p/1554580#M440567</link>
      <description>&lt;P&gt;hi,&lt;/P&gt;&lt;P&gt;i have a bar chart that i need in each month one bar need to be stacked and one&amp;nbsp; not stacked.&lt;/P&gt;&lt;P&gt;to do it im using a dimension called "_bar" with the values 1,2&lt;/P&gt;&lt;P&gt;_bar=1 its the stacked and 2 not stacked&lt;/P&gt;&lt;P&gt;i have 3 expressions ex1,2 go to _bar=1&lt;/P&gt;&lt;P&gt;and ex3 go to _bar=2.&lt;/P&gt;&lt;P&gt;its all work fine &lt;U&gt;but&lt;/U&gt; in need to have set analysis on the year end month selection/&lt;/P&gt;&lt;P&gt;i want to see the bar in all the months.&lt;/P&gt;&lt;P&gt;and the the condition with the _bar dont allow me to see it in all the month.&lt;/P&gt;&lt;P&gt;&amp;nbsp;i tried-&lt;/P&gt;&lt;P&gt;=if(only({&amp;lt;SAVE_MONTH={"&amp;gt;=$(vLastYearDate)&amp;lt;=$(vCurrYearDate)"},Year=,Month=,Quarter=&amp;gt;}_BAR)=1,&lt;BR /&gt;FABS(sum({&amp;lt;SAVE_MONTH={"&amp;gt;=$(vLastYearDate)&amp;lt;=$(vCurrYearDate)"},Year=,Month=,Quarter=,ST_TRANS_LOGIC={'Issue3'},DSLW_ORDER_TYPE={'slow to raw'}&amp;gt;}ST_VALUE_USD))/1000)&lt;/P&gt;&lt;P&gt;NOT WORKING...&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 796px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/7654i1A250F9F02BE1F54/image-size/large?v=v2&amp;amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;someone can help?&lt;/P&gt;&lt;P&gt;adi&lt;/P&gt;</description>
      <pubDate>Sun, 10 Mar 2019 07:18:26 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/bar-chart-one-bar-stack-and-one-not/m-p/1554580#M440567</guid>
      <dc:creator>adiarnon</dc:creator>
      <dc:date>2019-03-10T07:18:26Z</dc:date>
    </item>
    <item>
      <title>Re: bar chart one bar stack and one not</title>
      <link>https://community.qlik.com/t5/QlikView/bar-chart-one-bar-stack-and-one-not/m-p/1554599#M440571</link>
      <description>Can you please share sample data with app, that will help to identify issue.&lt;BR /&gt;&lt;BR /&gt;Regards,&lt;BR /&gt;Vishal</description>
      <pubDate>Sun, 10 Mar 2019 13:03:49 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/bar-chart-one-bar-stack-and-one-not/m-p/1554599#M440571</guid>
      <dc:creator>VishalWaghole</dc:creator>
      <dc:date>2019-03-10T13:03:49Z</dc:date>
    </item>
  </channel>
</rss>

