# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for
Did you mean:
Creator II

## Chart on the last 12 months

I want to show last 12 months in calculated dimension from current month.

6 Replies
MVP

Put months on dimension and expression using set analysis like:

sum({<Date={'>\$(=monthstart(max(Date),-12))'}>}Amount)

MVP

Hi,

Try this if you have any Month Year Field

=SUM({<[Month Year]= {'>=\$(=(Max([Month Year])-12))<=\$(=Max([Month Year]) )'}>}Revenue)

Regards

Anand

MVP

Hi, you need to ignore selections on date related fields and limit the values for the last 12 months

Sum({<Year,Quarter,Month,DateField={'>\$(=MonthStart(max(DateField),-12))<=\$(=max(DateField))'}>} ValueField)

Partner - Specialist

Hi,

Using Set Analysis in your expression and dimension can be month or MonthYear field  :

sum({<DATE={'>=\$(=MonthStart(Max(DATE),-12))<=\$(=MonthEnd(Max(DATE),-1))'}>}amount)

Not applicable

if(date(date_column,'D/M/YYYY') > date(ur_date, 'date_format') and  date(date_column,'D/M/YYYY') < date(ur_date, 'date_format'), date_column, null())

date_column is dimension field

ur_Date - u can keep date static or dynamic

MVP

Another One way is

And in dimension Take MonthYear Field

Expre:-  Sum({<Date ={'>\$(=((AddMonths( Max(Date),-11))))<=\$(=( Max(Date)) )'}>} Sales)

Regards

Anand

Community Browser