Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. 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)