topic Previous Month Sales in QlikView

Previous Month Sales

Thu, 15 Dec 2011 14:59:07 GMT

Hi,

I'm trying to query sales from 8 months ago. Using the following query, I'm able to sum the current month's sales using the following:

[Calendar Month Name] = {'$(=month(now(0)))'}

However I cannot use the above query to sum sales for a previous month. For instance if I try:

[Calendar Month Name] = {'$(=month(now(0)-8))'}

[Calendar Month Name] = {'$(=month(now(0))-8)'}

Both return nothing. Does anyone have an idea what I'm missing? I've searched the forum and have yet to find a solution.

Any help is appreciated.

Matt

Previous Month Sales

jagan — Thu, 15 Dec 2011 15:23:51 GMT

Hi,

Try this

[Calendar Month Name] = {'$(=month(AddMonths(now(0), -8)))'}

Hope this helps you.

Regards,

Jagan.

Previous Month Sales

Thu, 15 Dec 2011 16:10:19 GMT

Thanks Jagan,

That works perfectly! One issue though. I'm using this with other selections that are overriding the expression. How would I change the following set to ignore current selections and pull the data I'm looking for 8 months ago:

I've tried using a 1 intstead of a $ sign expansion, but was unsuccessful.

Thanks again for the help.

Matt

Previous Month Sales

Thu, 15 Dec 2011 16:39:24 GMT

Nevermind, I was able to figure it out, had misplaced my 1, which needs to go at the beginning of the expression.

Best,

Matt