Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
sureshbn121
Contributor II
Contributor II

I need syantax to get Last six months data?

Pls send me ...

1 Solution

Accepted Solutions
timpoismans
Specialist
Specialist

I take it you want to limit the load in your script?

Do you have a date field?

Do you take the current month as part of the six months, even though it's not complete?

Give us a bit more info so we can help you out.

View solution in original post

2 Replies
timpoismans
Specialist
Specialist

I take it you want to limit the load in your script?

Do you have a date field?

Do you take the current month as part of the six months, even though it's not complete?

Give us a bit more info so we can help you out.

justinphamvn
Creator II
Creator II

Hi,

May try like this:

// Sum Last six months Sales

sum(

          {

              <

                date=,

                Year=,

                Month=,

                Quarter=,

                    date={">=$(=AddMonths(Max(date),-6))<=$(=Max(date))"}

              >

          }

Sales)

Hope this helps,

Justin.