topic Re: how to start a chart with current year ? in QlikView https://community.qlik.com/t5/QlikView/how-to-start-a-chart-with-current-year/m-p/733926#M262886 <HTML><HEAD></HEAD><BODY><P>I would try set analysis and sorting the chart. I assume you have the year and quarter fields splited.</P><P></P><P>Please, check my example.</P></BODY></HTML> Wed, 01 Oct 2014 11:28:01 GMT carvalguil 2014-10-01T11:28:01Z how to start a chart with current year ? https://community.qlik.com/t5/QlikView/how-to-start-a-chart-with-current-year/m-p/733924#M262884 <HTML><HEAD></HEAD><BODY><P>hello ,</P><P></P><P>i have a set of years starting 2012 going upto 2020. for which i have created a field called yearquarter, eg:2012Q1,2012Q2 etc.</P><P>two scenarios need to be achived.</P><P>1&gt; to show year starting from current year, yearquarter ie : 2014Q1</P><P>2&gt;to change every year, for ex: when the year turns 2015, it automatically switches from 2014Q1 values and show data starting 2015Q1</P><P>how can this be achived ?</P></BODY></HTML> Wed, 01 Oct 2014 11:06:10 GMT https://community.qlik.com/t5/QlikView/how-to-start-a-chart-with-current-year/m-p/733924#M262884 bell_byloli 2014-10-01T11:06:10Z Re: how to start a chart with current year ? https://community.qlik.com/t5/QlikView/how-to-start-a-chart-with-current-year/m-p/733925#M262885 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>We too had similar scenario, wherein we have one master calendar saved separately in database and it updates another table which has dates only till current date/quarter so that Max Year command in the expression will work.&nbsp; You can try similar approach wherein the master file which you pull into QlikView has only date/Quarter&nbsp; till current date.</P></BODY></HTML> Wed, 01 Oct 2014 11:11:17 GMT https://community.qlik.com/t5/QlikView/how-to-start-a-chart-with-current-year/m-p/733925#M262885 raghavsurya 2014-10-01T11:11:17Z Re: how to start a chart with current year ? https://community.qlik.com/t5/QlikView/how-to-start-a-chart-with-current-year/m-p/733926#M262886 <HTML><HEAD></HEAD><BODY><P>I would try set analysis and sorting the chart. I assume you have the year and quarter fields splited.</P><P></P><P>Please, check my example.</P></BODY></HTML> Wed, 01 Oct 2014 11:28:01 GMT https://community.qlik.com/t5/QlikView/how-to-start-a-chart-with-current-year/m-p/733926#M262886 carvalguil 2014-10-01T11:28:01Z