<?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 How to filter values in a bar chart based on filtered values from a dimension in App Development</title>
    <link>https://community.qlik.com/t5/App-Development/How-to-filter-values-in-a-bar-chart-based-on-filtered-values/m-p/6121#M485</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P style="font-size: 13.3333px;"&gt;Hi,&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;I am really new to Qlik and i need to filter data in order to only process that portion on a single sheet&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;I can defend myself on Tableau but Qlik seems very different.&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;I have created a calculated dimension called "Dimension2" with the following formula:&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;if(match(left(details, 19),'DataRoam Unlimited:'), details&lt;SPAN style="font-size: 10pt;"&gt;)&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;SPAN style="font-size: 10pt;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;SPAN style="font-size: 10pt;"&gt;Dimension2 = If match from char 1 to 19 of "details" dimension, show the dimension value match in that same row in "details"&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;SPAN style="font-size: 10pt;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;SPAN style="font-size: 10pt;"&gt;I am expecting to &lt;STRONG&gt;only show&lt;/STRONG&gt; as the dimension values with a match in a bar chart with the sum of a measure related to that dimension as long as it is matched based on the truncation rule of 19 characters.&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;SPAN style="font-size: 10pt;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;SPAN style="font-size: 10pt;"&gt;With this formula I am still getting the entire list of values of the dimension so the filtering/matching i devised is not working at all.&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 24 Jan 2018 07:51:27 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2018-01-24T07:51:27Z</dc:date>
    <item>
      <title>How to filter values in a bar chart based on filtered values from a dimension</title>
      <link>https://community.qlik.com/t5/App-Development/How-to-filter-values-in-a-bar-chart-based-on-filtered-values/m-p/6121#M485</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P style="font-size: 13.3333px;"&gt;Hi,&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;I am really new to Qlik and i need to filter data in order to only process that portion on a single sheet&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;I can defend myself on Tableau but Qlik seems very different.&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;I have created a calculated dimension called "Dimension2" with the following formula:&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;if(match(left(details, 19),'DataRoam Unlimited:'), details&lt;SPAN style="font-size: 10pt;"&gt;)&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;SPAN style="font-size: 10pt;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;SPAN style="font-size: 10pt;"&gt;Dimension2 = If match from char 1 to 19 of "details" dimension, show the dimension value match in that same row in "details"&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;SPAN style="font-size: 10pt;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;SPAN style="font-size: 10pt;"&gt;I am expecting to &lt;STRONG&gt;only show&lt;/STRONG&gt; as the dimension values with a match in a bar chart with the sum of a measure related to that dimension as long as it is matched based on the truncation rule of 19 characters.&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;SPAN style="font-size: 10pt;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;SPAN style="font-size: 10pt;"&gt;With this formula I am still getting the entire list of values of the dimension so the filtering/matching i devised is not working at all.&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 24 Jan 2018 07:51:27 GMT</pubDate>
      <guid>https://community.qlik.com/t5/App-Development/How-to-filter-values-in-a-bar-chart-based-on-filtered-values/m-p/6121#M485</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2018-01-24T07:51:27Z</dc:date>
    </item>
    <item>
      <title>Re: How to filter values in a bar chart based on filtered values from a dimension</title>
      <link>https://community.qlik.com/t5/App-Development/How-to-filter-values-in-a-bar-chart-based-on-filtered-values/m-p/6122#M486</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Would you be able to share a sample to show what isn't working?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 24 Jan 2018 18:38:48 GMT</pubDate>
      <guid>https://community.qlik.com/t5/App-Development/How-to-filter-values-in-a-bar-chart-based-on-filtered-values/m-p/6122#M486</guid>
      <dc:creator>sunny_talwar</dc:creator>
      <dc:date>2018-01-24T18:38:48Z</dc:date>
    </item>
  </channel>
</rss>

