Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Showing the values of last 12 months

how to show the sales of last 12 month(fiscal year) when i select august 2011?? i.e i want to see sales from july to aug(2010-2011)

2 Replies
john_duffy
Contributor III

Re: Showing the values of last 12 months

Hello.

You can use a set analysis statement something like:

Sum({1<[Data Date] = {>=$(=date(addmonths(monthstart(makedate([Selected Year],[Selected Month])),-11))) <$(=date(addmonths(monthstart(makedate([Selected Year],[Selected Month])),+1))) Cntr

Note: synatx not verified.

John.

MVP
MVP

Showing the values of last 12 months

Hi,

Try this expression

=Sum({<DateField={'>=$(=MonthStart(Max(DateField), -11))<=$(=Max(DateField))'}>} Sales)

Replace "DateField" with your dimension name.

Hope this helps you.

Regards,

jagan.