Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
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.

View solution in original post

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.