Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
pratik_advani
Contributor
Contributor

Set analysis for months

Hi, I want to calculate sales for salesman for the next 2 months from the current month. Let us say the current month is july and I want to calculate for august and september.

2 Replies
ashfaq_haseeb

Try like this

=Sum({<Date={">=$(=MonthStart(AddMonths(Max(Date),+1)))<=$(=MonthEnd(AddMonths(Max(Date),+2)))"}>}Sales)

Regards

ASHFAQ

jagan
MVP
MVP

Hi,

Try like this

=Sum({<MonthDimensionName=, YearDimensionName=, DateDimensionName={">=$(=MonthStart(AddMonths(Max(DateDimensionName),1)))<=$(=MonthEnd(AddMonths(Max(DateDimensionName),2)))"}>}Sales)


Note: Replace MonthDimensionName, YearDimensionName, DateDimensionName with your actual field names.


Regards,

Jagan.