<?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 make a chart which shows a difference of 2 charts data? in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/How-to-make-a-chart-which-shows-a-difference-of-2-charts-data/m-p/2011964#M1221787</link>
    <description>&lt;P&gt;I have a beginner's question about visualizing data in QlikSense.&lt;/P&gt;
&lt;P&gt;There is a table which contains rented bike routes: from one exchange station to another. It has fields: &lt;SPAN data-sheets-value="{&amp;quot;1&amp;quot;:2,&amp;quot;2&amp;quot;:&amp;quot;Start Station Name&amp;quot;}" data-sheets-userformat="{&amp;quot;2&amp;quot;:513,&amp;quot;3&amp;quot;:{&amp;quot;1&amp;quot;:0},&amp;quot;12&amp;quot;:0}"&gt;Start Station Name and End Station Name&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN data-sheets-value="{&amp;quot;1&amp;quot;:2,&amp;quot;2&amp;quot;:&amp;quot;Start Station Name&amp;quot;}" data-sheets-userformat="{&amp;quot;2&amp;quot;:513,&amp;quot;3&amp;quot;:{&amp;quot;1&amp;quot;:0},&amp;quot;12&amp;quot;:0}"&gt;I can visualize, how many times each station was the Start and how many times was it the End of the route. I did it by building 2 vertical grouped bar charts:&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN data-sheets-value="{&amp;quot;1&amp;quot;:2,&amp;quot;2&amp;quot;:&amp;quot;Start Station Name&amp;quot;}" data-sheets-userformat="{&amp;quot;2&amp;quot;:513,&amp;quot;3&amp;quot;:{&amp;quot;1&amp;quot;:0},&amp;quot;12&amp;quot;:0}"&gt;Start station name vs Count([Start station name]) and End station name vs Count([End station name]) &lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;Now I want to show, which stations will have surplus of bins, and which ones will have the shortage of them.&lt;/P&gt;
&lt;P&gt;But is I build a chart with Start Station Name as a dimension and &lt;SPAN data-sheets-value="{&amp;quot;1&amp;quot;:2,&amp;quot;2&amp;quot;:&amp;quot;Start Station Name&amp;quot;}" data-sheets-userformat="{&amp;quot;2&amp;quot;:513,&amp;quot;3&amp;quot;:{&amp;quot;1&amp;quot;:0},&amp;quot;12&amp;quot;:0}"&gt;Count([Start station name]) - Count([End station name]) as a measure, I get 0's&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN data-sheets-value="{&amp;quot;1&amp;quot;:2,&amp;quot;2&amp;quot;:&amp;quot;Start Station Name&amp;quot;}" data-sheets-userformat="{&amp;quot;2&amp;quot;:513,&amp;quot;3&amp;quot;:{&amp;quot;1&amp;quot;:0},&amp;quot;12&amp;quot;:0}"&gt;Is my task achievable in QlikSense?&lt;/SPAN&gt;&lt;/P&gt;</description>
    <pubDate>Fri, 02 Dec 2022 09:20:47 GMT</pubDate>
    <dc:creator>Airapport</dc:creator>
    <dc:date>2022-12-02T09:20:47Z</dc:date>
    <item>
      <title>How to make a chart which shows a difference of 2 charts data?</title>
      <link>https://community.qlik.com/t5/QlikView/How-to-make-a-chart-which-shows-a-difference-of-2-charts-data/m-p/2011964#M1221787</link>
      <description>&lt;P&gt;I have a beginner's question about visualizing data in QlikSense.&lt;/P&gt;
&lt;P&gt;There is a table which contains rented bike routes: from one exchange station to another. It has fields: &lt;SPAN data-sheets-value="{&amp;quot;1&amp;quot;:2,&amp;quot;2&amp;quot;:&amp;quot;Start Station Name&amp;quot;}" data-sheets-userformat="{&amp;quot;2&amp;quot;:513,&amp;quot;3&amp;quot;:{&amp;quot;1&amp;quot;:0},&amp;quot;12&amp;quot;:0}"&gt;Start Station Name and End Station Name&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN data-sheets-value="{&amp;quot;1&amp;quot;:2,&amp;quot;2&amp;quot;:&amp;quot;Start Station Name&amp;quot;}" data-sheets-userformat="{&amp;quot;2&amp;quot;:513,&amp;quot;3&amp;quot;:{&amp;quot;1&amp;quot;:0},&amp;quot;12&amp;quot;:0}"&gt;I can visualize, how many times each station was the Start and how many times was it the End of the route. I did it by building 2 vertical grouped bar charts:&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN data-sheets-value="{&amp;quot;1&amp;quot;:2,&amp;quot;2&amp;quot;:&amp;quot;Start Station Name&amp;quot;}" data-sheets-userformat="{&amp;quot;2&amp;quot;:513,&amp;quot;3&amp;quot;:{&amp;quot;1&amp;quot;:0},&amp;quot;12&amp;quot;:0}"&gt;Start station name vs Count([Start station name]) and End station name vs Count([End station name]) &lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;Now I want to show, which stations will have surplus of bins, and which ones will have the shortage of them.&lt;/P&gt;
&lt;P&gt;But is I build a chart with Start Station Name as a dimension and &lt;SPAN data-sheets-value="{&amp;quot;1&amp;quot;:2,&amp;quot;2&amp;quot;:&amp;quot;Start Station Name&amp;quot;}" data-sheets-userformat="{&amp;quot;2&amp;quot;:513,&amp;quot;3&amp;quot;:{&amp;quot;1&amp;quot;:0},&amp;quot;12&amp;quot;:0}"&gt;Count([Start station name]) - Count([End station name]) as a measure, I get 0's&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN data-sheets-value="{&amp;quot;1&amp;quot;:2,&amp;quot;2&amp;quot;:&amp;quot;Start Station Name&amp;quot;}" data-sheets-userformat="{&amp;quot;2&amp;quot;:513,&amp;quot;3&amp;quot;:{&amp;quot;1&amp;quot;:0},&amp;quot;12&amp;quot;:0}"&gt;Is my task achievable in QlikSense?&lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Fri, 02 Dec 2022 09:20:47 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/How-to-make-a-chart-which-shows-a-difference-of-2-charts-data/m-p/2011964#M1221787</guid>
      <dc:creator>Airapport</dc:creator>
      <dc:date>2022-12-02T09:20:47Z</dc:date>
    </item>
  </channel>
</rss>

