topic Re: Bar graph with previous 12 months in QlikView

Bar graph with previous 12 months

Thu, 19 Nov 2015 23:08:21 GMT

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.

Re: Bar graph with previous 12 months

sunny_talwar — Thu, 19 Nov 2015 23:43:04 GMT

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

Re: Bar graph with previous 12 months

Fri, 20 Nov 2015 14:42:50 GMT

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.

Period	2015
1	1,128,292.3
2	978,284.0
3	998,071.2
4	1,548,605.0
5	1,092,847.5
6	978,938.3
7	1,047,483.8
8	970,740.8
9	636,116.6
10	558,025.4
11	497,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.