Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
dsdeepak284
New 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

Re: Expression to calculate past 3 months sale in straight table

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

Re: Expression to calculate past 3 months sale in straight table

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
Valued Contributor

Re: Expression to calculate past 3 months sale in straight table

try

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