topic Year and Month value Calculation in QlikView

Year and Month value Calculation

Tue, 06 Oct 2009 22:37:35 GMT

Hi,

I am trying to compare values from this year this month and last year this month in pivot table.

For this year column I am using:

sum({<Invoice_Date.Year = {$(=GetFieldSelections(Invoice_Date.Year))}, Invoice_Date.Month = {$(=GetFieldSelections(Invoice_Date.Month))}>} [sop.val])

and for last year this month column i am using

sum({<Invoice_Date.Year = {$(=GetFieldSelections(Invoice_Date.Year)-1)}, Invoice_Date.Month = {$(=GetFieldSelections(Invoice_Date.Month))}>} [sop.val])

however the values showing are all zeros.

Any help will be greatly appreciated

Year and Month value Calculation

Wed, 07 Oct 2009 18:57:15 GMT

Hi,

try to evaluate the example.

Good luck!

Rainer

Year and Month value Calculation

Wed, 07 Oct 2009 23:10:17 GMT

Thanks Rainer,

It shows the aggregate for last three month. Is there any way to identify figures for last year this month.

Year and Month value Calculation

Thu, 08 Oct 2009 14:33:07 GMT

Hello again,

I have modified the application in the way you asked.

Hope it helps a lot!

Rainer

Year and Month value Calculation

Thu, 08 Oct 2009 14:39:40 GMT

Here are the attachment.

Year and Month value Calculation

Thu, 08 Oct 2009 15:41:43 GMT

Many Thanks. It worked.