how to start a chart with current year ?

[bell_byloli]

hello ,

i have a set of years starting 2012 going upto 2020. for which i have created a field called yearquarter, eg:2012Q1,2012Q2 etc.

two scenarios need to be achived.

1> to show year starting from current year, yearquarter ie : 2014Q1

2>to change every year, for ex: when the year turns 2015, it automatically switches from 2014Q1 values and show data starting 2015Q1

how can this be achived ?

[raghavsurya]

Hi,

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.  You can try similar approach wherein the master file which you pull into QlikView has only date/Quarter  till current date.

[carvalguil]

I would try set analysis and sorting the chart. I assume you have the year and quarter fields splited.

Please, check my example.