Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Kohli
Creator II
Creator II

Calculate the last 3 months sales in straight table

Calculate the last 3 months sales in straight table.

Fields:

Month, Sales

2 Replies
Anil_Babu_Samineni

You can use this as measure?

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)
vishalarote
Partner
Partner

Try this,

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