<?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 Combined functioning of Global filter (Select Date Range) with Default State and Dedicated Filter (Select Date range)  with Alternate State in App Development</title>
    <link>https://community.qlik.com/t5/App-Development/Combined-functioning-of-Global-filter-Select-Date-Range-with/m-p/2005102#M83180</link>
    <description>&lt;P&gt;Hello Team,&lt;/P&gt;
&lt;P&gt;There are two dates in my data&lt;/P&gt;
&lt;OL&gt;
&lt;LI&gt;Ticket Creation date for values in line chart&lt;/LI&gt;
&lt;LI&gt;Customer Activation Date for values in bar chart.&lt;/LI&gt;
&lt;/OL&gt;
&lt;P&gt;So to consider both dates we have made one canonical master calendar based on these two dates and this Canonical date field is used in below highlighted Date Picker chart. From below three Date Picker charts the first Date Picker has default state and other two has alternate state with respect to that particular combo chart. So, first line of filters i.e. from Select Date Range, Year, Month, Country, State, City, Reach Plan Id, Lead Source, MVNE, and Old Carrier are global filters i.e. they have default state and Select date Range in container with combo chart have Alternate State.&lt;/P&gt;
&lt;P&gt;In combo chart Line represents total no. of tickets and Bar represents cumulative count of Active Customers.&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Prathamesh_Bait_0-1668586449754.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/93833i506501A8520ED4B8/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Prathamesh_Bait_0-1668586449754.png" alt="Prathamesh_Bait_0-1668586449754.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;So when we make any selections in default state filters highlighted below then combo chart is reflecting values according to the selections. Bars represent cumulative count and line represents ticket count.&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Prathamesh_Bait_1-1668586478475.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/93834i2A47CF933497AF54/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Prathamesh_Bait_1-1668586478475.png" alt="Prathamesh_Bait_1-1668586478475.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;And even if we select date range from default state Select Date Range filter then also it is showing cumulative bar values and correct ticket count in line. And this is expected output when we make selections in Date Range.&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Prathamesh_Bait_2-1668586503906.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/93835iC67143A7D5698F89/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Prathamesh_Bait_2-1668586503906.png" alt="Prathamesh_Bait_2-1668586503906.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;But when we make selections in Select Date Range Filter having Alternate State present in container for Tech Ticket Analysis chart and CS Ticket Analysis chart then it is not showing values as per expected output. It is showcasing the below output which is not correct.&lt;/P&gt;
&lt;P&gt;(The cumulative count of previous weeks / months / years is not being considered while making selections in Select date Range filter having Alternate State present in same container.)&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Prathamesh_Bait_3-1668586533078.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/93836iA0AAC0D948FD4BDF/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Prathamesh_Bait_3-1668586533078.png" alt="Prathamesh_Bait_3-1668586533078.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Wed, 16 Nov 2022 08:14:57 GMT</pubDate>
    <dc:creator>Prathamesh_Bait</dc:creator>
    <dc:date>2022-11-16T08:14:57Z</dc:date>
    <item>
      <title>Combined functioning of Global filter (Select Date Range) with Default State and Dedicated Filter (Select Date range)  with Alternate State</title>
      <link>https://community.qlik.com/t5/App-Development/Combined-functioning-of-Global-filter-Select-Date-Range-with/m-p/2005102#M83180</link>
      <description>&lt;P&gt;Hello Team,&lt;/P&gt;
&lt;P&gt;There are two dates in my data&lt;/P&gt;
&lt;OL&gt;
&lt;LI&gt;Ticket Creation date for values in line chart&lt;/LI&gt;
&lt;LI&gt;Customer Activation Date for values in bar chart.&lt;/LI&gt;
&lt;/OL&gt;
&lt;P&gt;So to consider both dates we have made one canonical master calendar based on these two dates and this Canonical date field is used in below highlighted Date Picker chart. From below three Date Picker charts the first Date Picker has default state and other two has alternate state with respect to that particular combo chart. So, first line of filters i.e. from Select Date Range, Year, Month, Country, State, City, Reach Plan Id, Lead Source, MVNE, and Old Carrier are global filters i.e. they have default state and Select date Range in container with combo chart have Alternate State.&lt;/P&gt;
&lt;P&gt;In combo chart Line represents total no. of tickets and Bar represents cumulative count of Active Customers.&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Prathamesh_Bait_0-1668586449754.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/93833i506501A8520ED4B8/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Prathamesh_Bait_0-1668586449754.png" alt="Prathamesh_Bait_0-1668586449754.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;So when we make any selections in default state filters highlighted below then combo chart is reflecting values according to the selections. Bars represent cumulative count and line represents ticket count.&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Prathamesh_Bait_1-1668586478475.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/93834i2A47CF933497AF54/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Prathamesh_Bait_1-1668586478475.png" alt="Prathamesh_Bait_1-1668586478475.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;And even if we select date range from default state Select Date Range filter then also it is showing cumulative bar values and correct ticket count in line. And this is expected output when we make selections in Date Range.&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Prathamesh_Bait_2-1668586503906.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/93835iC67143A7D5698F89/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Prathamesh_Bait_2-1668586503906.png" alt="Prathamesh_Bait_2-1668586503906.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;But when we make selections in Select Date Range Filter having Alternate State present in container for Tech Ticket Analysis chart and CS Ticket Analysis chart then it is not showing values as per expected output. It is showcasing the below output which is not correct.&lt;/P&gt;
&lt;P&gt;(The cumulative count of previous weeks / months / years is not being considered while making selections in Select date Range filter having Alternate State present in same container.)&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Prathamesh_Bait_3-1668586533078.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/93836iA0AAC0D948FD4BDF/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Prathamesh_Bait_3-1668586533078.png" alt="Prathamesh_Bait_3-1668586533078.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 16 Nov 2022 08:14:57 GMT</pubDate>
      <guid>https://community.qlik.com/t5/App-Development/Combined-functioning-of-Global-filter-Select-Date-Range-with/m-p/2005102#M83180</guid>
      <dc:creator>Prathamesh_Bait</dc:creator>
      <dc:date>2022-11-16T08:14:57Z</dc:date>
    </item>
  </channel>
</rss>

