I am attaching both sample excel file and sample qlikview document.
I want to make a rolling bar chart for quarterly data. The last bar will represent last possible quarter as per the data and previous bars will represent last n quarters depending upon the requirements of n.
My year start with April every year. So Q1 means Apr, May and Jun.
Please guide me in making the expression.
For Rolling Months data I am using following expression at present :
[Mon-Y]={">$(=Num(Addmonths(Max([Mon-Y]),-5))) <=$(=Max([Mon-Y]))"} - for 5 rolling periods
and dimension I am using is Date([Mon-Y],'MMM-YY')
Now I want to make similar expression for rolling quarters for dimension representing quarters.
My Financial year starts with Apr every year so Last bar will show H1-18 and it will consist of only Apr-17 and May-17 data of 2018 as of now as per this sample file.
Now the previous bar should show data from Oct-16 to Mar-17 and bar before this should show data from Apr-16 to Sep-16. This is what I want If I select 3 from the slider object.
