topic Re: Previous Year in QlikView

Previous Year

Wed, 25 Nov 2020 16:16:04 GMT

I am trying to find the previous invoice total for August last year and have used the following expression

Sum({<[Bill Date]={">= $(=monthstart(Monthend(today()+1,-12))) <=$(=monthend(today()+1,-12))"},

Year = {*},
Period = {*},
Date = {*},
Month = {*},
[Calendar Year] = {*},
QuarterName = {*},
[LinkId] = {"FIN"}
>}
[Bill Value] * $(RevenueRate))

I could hard code the values in to year and month but I need this t be dynamic so when I run for September 2016 I get September 2015 invoice total as wel

Any ideas

Re: Previous Year

kaushiknsolanki — Wed, 17 Aug 2016 11:37:21 GMT

Hi,

You should try this.

Sum({<[Bill Date]={">= $(=monthstart(Addmonths(today()+1,-12))) <=$(=Addmonths(today()+1,-12))"},

Year = ,

Period = ,

Date = ,

Month = ,

[Calendar Year] = ,

QuarterName = ,

[LinkId] = {"FIN"}

[Bill Value] * $(RevenueRate))

Regards,

Kaushik Solanki

Re: Previous Year

Wed, 17 Aug 2016 12:13:54 GMT

Hi, Thanks but that has summed the totals up incorrectly as well