Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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?

Highlighted

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)