Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
dsdeepak284
Contributor II
Contributor II

Expression to calculate past 3 months sale in straight table

Please help me with the expression to calculate past 3 months total sales in straight table.

3 Replies
Miguel_Angel_Baeyens

How your data model looks like? How is the date stored?

Anil_Babu_Samineni

Tough to say without knowing anything, But as assumption you may need

Sum({<Month = {">=$(=AddMonths(Max(Month), -3))<=$(=Max(Month))"}>} Sales)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
zebhashmi
Specialist
Specialist

try

Sum({<DateField={"<=Today()-3"}>}Sales)