https://community.qlik.com/t5/QlikView/Extract-data-between-2-months-given-by-the-user/m-p/1858480#M1216006 <P>Hello<BR />I have a graph plotted with 12 months on the x axis<BR />I want to display data between 2 selected months alone<BR />eg: If I select March and July, I want the data from March to July get plotted in the graph.<BR />How can we do that?</P> Fri, 12 Nov 2021 03:32:39 GMT Athira_K 2021-11-12T03:32:39Z https://community.qlik.com/t5/QlikView/Extract-data-between-2-months-given-by-the-user/m-p/1858480#M1216006 <P>Hello<BR />I have a graph plotted with 12 months on the x axis<BR />I want to display data between 2 selected months alone<BR />eg: If I select March and July, I want the data from March to July get plotted in the graph.<BR />How can we do that?</P> Fri, 12 Nov 2021 03:32:39 GMT https://community.qlik.com/t5/QlikView/Extract-data-between-2-months-given-by-the-user/m-p/1858480#M1216006 Athira_K 2021-11-12T03:32:39Z https://community.qlik.com/t5/QlikView/Extract-data-between-2-months-given-by-the-user/m-p/1858626#M1216015 <P>HI Athira,</P> <P>Try like below</P> <P>If you have date field, try like below</P> <P>Sum({&lt;Date={"&gt;=$(=MonthStart(Min(Date)))&lt;=$(=MonthEnd(Max(Date)))"}, Month=, Year=&gt;}UrExp)</P> Fri, 12 Nov 2021 10:24:00 GMT https://community.qlik.com/t5/QlikView/Extract-data-between-2-months-given-by-the-user/m-p/1858626#M1216015 MayilVahanan 2021-11-12T10:24:00Z