topic Qlik Sense - Limiting the date range with Rangesum in App Development https://community.qlik.com/t5/App-Development/Qlik-Sense-Limiting-the-date-range-with-Rangesum/m-p/58566#M3898 <HTML><HEAD></HEAD><BODY><P>Hey everyone, </P><P>I've found a bunch of articles on here in regards to QlikView with examples, but I don't have Qlikview, so I can't view the files. </P><P></P><P>I'm trying to limit my date range on my X axis. The equation that we are working with relies on monthly data as well as cumulative data. </P><P>When I limit the date range with a dimension it breaks the cumulative data. </P><P></P><P><IMG alt="date fix.png" class="jive-image image-1" src="/legacyfs/online/193961_date fix.png" style="height: 214px; width: 620px;" /></P><P>What we want to do is not lose the data prior to Aug 2015, we just don't want to display it. Any suggestions?</P><P>Thanks,</P><P>Troy</P></BODY></HTML> Tue, 20 Feb 2018 19:19:07 GMT shearwatertroy 2018-02-20T19:19:07Z Qlik Sense - Limiting the date range with Rangesum https://community.qlik.com/t5/App-Development/Qlik-Sense-Limiting-the-date-range-with-Rangesum/m-p/58566#M3898 <HTML><HEAD></HEAD><BODY><P>Hey everyone, </P><P>I've found a bunch of articles on here in regards to QlikView with examples, but I don't have Qlikview, so I can't view the files. </P><P></P><P>I'm trying to limit my date range on my X axis. The equation that we are working with relies on monthly data as well as cumulative data. </P><P>When I limit the date range with a dimension it breaks the cumulative data. </P><P></P><P><IMG alt="date fix.png" class="jive-image image-1" src="/legacyfs/online/193961_date fix.png" style="height: 214px; width: 620px;" /></P><P>What we want to do is not lose the data prior to Aug 2015, we just don't want to display it. Any suggestions?</P><P>Thanks,</P><P>Troy</P></BODY></HTML> Tue, 20 Feb 2018 19:19:07 GMT https://community.qlik.com/t5/App-Development/Qlik-Sense-Limiting-the-date-range-with-Rangesum/m-p/58566#M3898 shearwatertroy 2018-02-20T19:19:07Z Re: Qlik Sense - Limiting the date range with Rangesum https://community.qlik.com/t5/App-Development/Qlik-Sense-Limiting-the-date-range-with-Rangesum/m-p/1735625#M56203 <P>I am having this issue as well! I am comparing YOY volumes and while I need the data from last year to compare to the current year's data, I do not want last year's dates displayed on my line chart.&nbsp;</P> Thu, 13 Aug 2020 14:21:47 GMT https://community.qlik.com/t5/App-Development/Qlik-Sense-Limiting-the-date-range-with-Rangesum/m-p/1735625#M56203 PJSullivan 2020-08-13T14:21:47Z