Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Bar graph with previous 12 months

sum({$<
[Bill Date]  = {"<=$(_SysCalendarLastWorkingDayCurrYear)>=$(_SysCalendarYearStartCurrYear)"},
Year = {*},
Period = {*},
Date = {*},
Month = {*},
[Calendar Year] = {*},
QuarterName = {*},
[Item Group Code] = {500, 501, 510, 530, 100},
[LinkId] = {"FIN"}
>}
[Bill Value] * $(RevenueRate))

I know this has been answered, but I can't find a posting simple enough for my level of expertise.

The code above deliveries each of the last 11 months from November 2015 to January 2015 by month.

I want to show the previous 12 months.  Ex:  November 2014 to October 2015 for a chart printed today (November 19, 2015).  Next month the data will show December 2014 to November 2015.

I apologize for asking a question that has been answered before, but I could not get those answers to work.  Thank you for all your help.

1 Solution

Accepted Solutions
Not applicable
Author

I hate to admit this Sunny but I spent several hours reading postings on this site and trying alternative answers. I try to solve the problem myself before posting.  But  at this point I am completely lost.

Perhaps the best response is to describe what I am trying to do and ask for help with the correct variables and expression:

For the prior twelve months I want to show the total sales by month.  This is not a rolling total but each month is individually reported.  This table reports only the months in the current year.

 

Period2015
11,128,292.3
2978,284.0
3998,071.2
41,548,605.0
51,092,847.5
6978,938.3
71,047,483.8
8970,740.8
9636,116.6
10558,025.4
11497,362.4

How do I get the months of Dec-14, Nov-14, Oct-14, etc?  (now the boss wants 18 month history).  How do I set it up so next month old history drops off and the latest month is picked up?  The date field I need to filter on is [Bill Date].  The [Bill Date] filed looks like '01/05/2015'.

Thank you.

View solution in original post

2 Replies
sunny_talwar

What is the expression you are using for this variable -> $(_SysCalendarYearStartCurrYear)

Not applicable
Author

I hate to admit this Sunny but I spent several hours reading postings on this site and trying alternative answers. I try to solve the problem myself before posting.  But  at this point I am completely lost.

Perhaps the best response is to describe what I am trying to do and ask for help with the correct variables and expression:

For the prior twelve months I want to show the total sales by month.  This is not a rolling total but each month is individually reported.  This table reports only the months in the current year.

 

Period2015
11,128,292.3
2978,284.0
3998,071.2
41,548,605.0
51,092,847.5
6978,938.3
71,047,483.8
8970,740.8
9636,116.6
10558,025.4
11497,362.4

How do I get the months of Dec-14, Nov-14, Oct-14, etc?  (now the boss wants 18 month history).  How do I set it up so next month old history drops off and the latest month is picked up?  The date field I need to filter on is [Bill Date].  The [Bill Date] filed looks like '01/05/2015'.

Thank you.