Is it possible to view 18 months data in qlikview

[ferha_jafri]

Hello Everyone,

I have a query regarding the feasability of qlikview as, is it possible to view last 18 month data in qlikview because in qlikview the summation happend as if we want to calculate sum of sales per month basis ,it will take one month suppose april and add all vales for that month for all yeras so one month is present only one time so my issue is whether one month can be repeted so we can calculate 18 months data ??

Thanks in advance

With regards

Ferha Jafri.

[tresesco]

Use MonthName() function like : MonthName(DateField) in your dimension (calculated or at the script). This will produce your month name along with the year.

monthname ( '2001-10-19' ) - returns 'Oct 2001'

monthname ( '2002-10-19' ) - returns 'Oct 2002'

Hence, you get the same month in the dimension but diffrentiated with corresponding year.

[brijesh1991]

yes.. that's simple. . .just nullify the year in your expression

[ferha_jafri]

If am applying monthname in the dimension then it is not filterring the data on the basis of expression i am attaing the file.

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[kaushiknsolanki]

Hi,

     Try this expression.

     sum({<Date ={">=$(=Addmonths(MonthStart(max(Date)),-17))<=$(=max(Date))"},Year=,month=,Quarter=>}[Sales Amount])

Regards,

Kaushik Solanki

[ferha_jafri]

Thank you so much Gysbert,and everyone as everyone's solution is correct when it comes to expression the dimension has to be changed thank you everyone there who take time to help me it is becuase of all of you that i am be able to learn Qlikview without having any BI background thank you again...

[#8]

Hello everyone I have created a graph that show Moving Average 12 Months that shows data from 2012 to end of 2014. I want to restrict the graph to only show months from Jan 2013 and later. Not affecting the calculation. Do anyone have an idea how to do this?