Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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)