topic Re: Showing previous month in QlikView

Showing previous month

pauldamen — Thu, 14 Mar 2013 09:07:50 GMT

All,

I have a very simple question but can't seem to figure it out.

I am trying to create a table with the first colum the month selected and the next colum should show the previous month (so if i selected march I want to see february in the next colum)

And for some reason I can't get it to work, I tried everything from month-1 to all kinds of date fields.

Hope someone can help me.

Regards, Paul

Re: Showing previous month

Thu, 14 Mar 2013 09:12:25 GMT

Can you post sample data ?

Re: Showing previous month

sushil353 — Thu, 14 Mar 2013 09:14:07 GMT

try this:

present month;

sum({<date={'$(max(date))'}>}value)

previous month:

sum({<date={'$(=addmonths(date,-1))'}>}value)

HTH

Sushil

Re: Showing previous month

pauldamen — Thu, 14 Mar 2013 09:19:01 GMT

Hi Sushil,

I tried your option but still only showing 0.

I attached the file, it is the second tab, I am using the textboxes to test.

Regards,

Paul

Re: Showing previous month

Thu, 14 Mar 2013 09:22:44 GMT

Dear Member,

Create Two Variables

Var1:----------max(month(date)) --------------------- currmonth

var2 '''''''''''''''''''''''addmonths(max(month(date,-1)) -------------- prev month

Re: Showing previous month

nirav_bhimani — Thu, 14 Mar 2013 09:24:49 GMT

HI,

Previous Month:

=sum({<CalYear={$(=max(CalYear))},CalMonth={$(=month(addmonths((max(Date)),-1)))}>}Sales)

Current Month:

=sum({<CalYear={$(=max(CalYear))},CalMonth={$(=Month(Max(Date)))}>} Sales)

Regards,

Nirav Bhimani

Re: Showing previous month

manideep78 — Thu, 14 Mar 2013 09:31:08 GMT

Try this expression in your test box where you are testing your previous one

=Date(Date#(AddMonths(Month,-1),'MM-DD-YYYY'),'MMM')

pauldamen — Thu, 14 Mar 2013 10:10:17 GMT

Thanks for your help! Works great

Re: Showing previous month

Thu, 14 Mar 2013 10:14:03 GMT

Is this working exactly?

Re: Showing previous month

pauldamen — Thu, 14 Mar 2013 10:14:50 GMT

As far as I can see yes!