<?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 Re: How to get the all the parts of a step? in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/How-to-get-the-all-the-parts-of-a-step/m-p/1017597#M465959</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;You will need this also as a filter to your expressions, maybe in this way:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;sum({&amp;lt; Stepnumber = {"$(=Subfield(Concat(DISTINCT Stepnumber,',', Stepnumber),',',&lt;SPAN style="color: #ff0000;"&gt;1&lt;/SPAN&gt;))"}&amp;gt;} YourValue)&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;- Marcus&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 24 Feb 2016 15:25:49 GMT</pubDate>
    <dc:creator>marcus_sommer</dc:creator>
    <dc:date>2016-02-24T15:25:49Z</dc:date>
    <item>
      <title>How to get the all the parts of a step?</title>
      <link>https://community.qlik.com/t5/QlikView/How-to-get-the-all-the-parts-of-a-step/m-p/1017596#M465958</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;the frist problem was this one:&lt;/P&gt;&lt;P&gt;&lt;A href="https://community.qlik.com/thread/191267"&gt;Formular sorting one number&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Now there is a new problem which i can't solve:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG alt="Ansicht_bisher.png" class="jive-image image-1" height="267" src="https://community.qlik.com/legacyfs/online/115749_Ansicht_bisher.png" style="height: 267px; width: 759.785px;" width="760" /&gt;&lt;/P&gt;&lt;P&gt;I got the Stepnumbers and want to see the piceses/parts for on e step in one chart.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;At the end there should be a dynamik page with about 10 barcharts and the first one shows the number of parts in stepnumber one, the second in the second stepnumber.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The Funktion i used for getting the names of the charts dynamic is: =Subfield(Concat(DISTINCT(Stepnumber),','),',',&lt;SPAN style="color: #ff0000;"&gt;1&lt;/SPAN&gt;)&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;But i can't find a way that the frist chart only shows the number of parts from the frist step.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The frist step can be 10 or 20 or what the user was selecting. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Here are two tables from the database:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG alt="Table.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/115750_Table.png" style="height: auto;" /&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 24 Feb 2016 11:37:59 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/How-to-get-the-all-the-parts-of-a-step/m-p/1017596#M465958</guid>
      <dc:creator />
      <dc:date>2016-02-24T11:37:59Z</dc:date>
    </item>
    <item>
      <title>Re: How to get the all the parts of a step?</title>
      <link>https://community.qlik.com/t5/QlikView/How-to-get-the-all-the-parts-of-a-step/m-p/1017597#M465959</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;You will need this also as a filter to your expressions, maybe in this way:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;sum({&amp;lt; Stepnumber = {"$(=Subfield(Concat(DISTINCT Stepnumber,',', Stepnumber),',',&lt;SPAN style="color: #ff0000;"&gt;1&lt;/SPAN&gt;))"}&amp;gt;} YourValue)&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;- Marcus&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 24 Feb 2016 15:25:49 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/How-to-get-the-all-the-parts-of-a-step/m-p/1017597#M465959</guid>
      <dc:creator>marcus_sommer</dc:creator>
      <dc:date>2016-02-24T15:25:49Z</dc:date>
    </item>
  </channel>
</rss>

