topic Re: Current Year, Previous Month in QlikView

Current Year, Previous Month

Mon, 24 Sep 2012 16:46:02 GMT

I need to get the sum of revenue for the current year, previous month.

The file that I have loaded contains

Year

Period

Revenue

So if I look at the data today, I want to get the previous month's data, i.e. since today is year 2012 month 09, I want to see all revenue for year 2012 month 08

I am using the following set analysis but it doesn't seem to be working.

Do I have this set up wrong; any suggestions?????

Sum({$<FYear={$(=Max(Year))}, FPeriod={$(=Month(Today()-1))}>}REV_TOTAL)

Re: Current Year, Previous Month

alexpanjhc — Mon, 24 Sep 2012 17:49:56 GMT

Sum({$<FYear={$(=Max(Year))}, FPeriod={$(=Month(Today())-1)}>}REV_TOTAL)

i think the problem is the parenthese is not in the right place.

Re: Current Year, Previous Month

Mon, 24 Sep 2012 18:39:07 GMT

I made the change you suggested. When I try to put together the entire calcultion that I'm really trying to get, the program just churns & eventually gets a not responding.

Could there be something else wrong with my calculation; here it is:

sum([ARBalance])/Sum({$<FYear={$(=Max(Year))}, FPeriod={$(=Month(Today())-1)}>}REV_TOTAL))*30

I'm trying to get the DSO by taking the AR Balance & dividing by last month's sales and then multiplying by number of days in which we are using 30.

Re: Current Year, Previous Month

alexpanjhc — Mon, 24 Sep 2012 18:48:27 GMT

is the last parenthese needed? or you are missing a paranthese at the begining?

Sum({$<FYear={$(=Max(Year))}, FPeriod={$(=Month(Today())-1)}>}REV_TOTAL))

Re: Current Year, Previous Month

MayilVahanan — Mon, 24 Sep 2012 19:06:19 GMT

Try like this,

Use AddMonths function

Sum([ARBalance])/Sum({$<FYear={$(=Max(Year))}, FPeriod={$(=AddMonths(Today())-1)}>}REV_TOTAL)

Hope it helps