topic Select accumulative months in QlikView https://community.qlik.com/t5/QlikView/Select-accumulative-months/m-p/1181415#M888180 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have data with date. i.e.</P><P></P><P>Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Month</P><P>2015-01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jan</P><P>2015-02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Feb</P><P style="font-size: 13.3333px;">2015-01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jan</P><P style="font-size: 13.3333px;">2015-02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Feb</P><P style="font-size: 13.3333px;">2015-01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Mar</P><P style="font-size: 13.3333px;">2015-02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Apr</P><P style="font-size: 13.3333px;">2015-01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Apr</P><P style="font-size: 13.3333px;">2015-02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Feb</P><P></P><P>What I need is that when I select a month, it selects all the previous months of the year.</P><P>i.e.</P><P>If I select April in the filter, I need to automatically select January, February, March and April.</P><P>Is it possible? How?</P><P></P><P>Thanks!! </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT cristian_av 2020-11-25T16:16:04Z Select accumulative months https://community.qlik.com/t5/QlikView/Select-accumulative-months/m-p/1181415#M888180 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have data with date. i.e.</P><P></P><P>Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Month</P><P>2015-01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jan</P><P>2015-02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Feb</P><P style="font-size: 13.3333px;">2015-01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jan</P><P style="font-size: 13.3333px;">2015-02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Feb</P><P style="font-size: 13.3333px;">2015-01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Mar</P><P style="font-size: 13.3333px;">2015-02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Apr</P><P style="font-size: 13.3333px;">2015-01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Apr</P><P style="font-size: 13.3333px;">2015-02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Feb</P><P></P><P>What I need is that when I select a month, it selects all the previous months of the year.</P><P>i.e.</P><P>If I select April in the filter, I need to automatically select January, February, March and April.</P><P>Is it possible? How?</P><P></P><P>Thanks!! </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Select-accumulative-months/m-p/1181415#M888180 cristian_av 2020-11-25T16:16:04Z Re: Select accumulative months https://community.qlik.com/t5/QlikView/Select-accumulative-months/m-p/1181416#M888181 <HTML><HEAD></HEAD><BODY><P>Select it for this particular chart or is this for the complete dashboard?</P></BODY></HTML> Mon, 12 Sep 2016 14:26:38 GMT https://community.qlik.com/t5/QlikView/Select-accumulative-months/m-p/1181416#M888181 sunny_talwar 2016-09-12T14:26:38Z Re: Select accumulative months https://community.qlik.com/t5/QlikView/Select-accumulative-months/m-p/1181417#M888182 <HTML><HEAD></HEAD><BODY><P>For the dashboard!</P></BODY></HTML> Mon, 12 Sep 2016 15:13:57 GMT https://community.qlik.com/t5/QlikView/Select-accumulative-months/m-p/1181417#M888182 cristian_av 2016-09-12T15:13:57Z Re: Select accumulative months https://community.qlik.com/t5/QlikView/Select-accumulative-months/m-p/1181418#M888183 <HTML><HEAD></HEAD><BODY><P>Look into this for date range selections. This will move you toward the right direction. If you still have issues, please provide a sample so that we can help you better <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P><A href="https://community.qlik.com/thread/67712">Selecting Arbitrary Date Ranges</A></P></BODY></HTML> Mon, 12 Sep 2016 15:33:55 GMT https://community.qlik.com/t5/QlikView/Select-accumulative-months/m-p/1181418#M888183 sunny_talwar 2016-09-12T15:33:55Z