Solved: Re: Previous 3 Months Data - Qlik Community

Report Inappropriate Content · ‎2015-03-19

Hi,

I need to show in a table only the data for last 3 months. without any selection it should show the latest 3 month data of the max year. based on selection it should show the corresponding 3 month data.

i have a month Year field in my data with values like mar-15,feb-15.. etc

how can it be achieved?? pls help...

PrashantSangle · ‎2015-03-19

Hi,

In your expression

try like

sum({Date={">=$(=Date(Addmonths(max(Date),-3)))<=$(=Date(max(Date)))"}}Sales)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

PrashantSangle · ‎2015-03-19

Hi,

In your expression

try like

sum({Date={">=$(=Date(Addmonths(max(Date),-3)))<=$(=Date(max(Date)))"}}Sales)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂