Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
kavita25
Partner - Specialist
Partner - Specialist

How to show last 6 month with Month-Year as a dimension

Hi,

I want to show last 6 month of Order Date with month-year as a dimension of Sale Date.

I am able to achieve last 6 month of order date on the basis of selection of Month Year(Sale Date).

For e.g If i select Jun-2015, it shows Last 6 Months of Order Date i.e Jun Jul Aug Sep Oct Nov Dec.

Please help me with this issue.

Its Urgent.

Regards,

Kavita

1 Solution

Accepted Solutions
sunny_talwar

Or May be this without the equal sign in the second condition within if:

=Count(If(TravelDate >= MonthYear and TravelDate < AddMonths(MonthYear, 6), sss))

View solution in original post

18 Replies
Anonymous
Not applicable

may be like this?

Dimension: monthName(OrderDate)

Expression:  Sum({<OderDate, OderDate={'>=$(=Date(max(OrderDate)-180,'OrderDateFormat'))<=$(=date(max(OrderDate),'OrderDateFormat'))'} >} Sales)

kavita25
Partner - Specialist
Partner - Specialist
Author

I want last 6 month on the basis of Month Year of Sale Date.

sasikanth
Master
Master

HI,

try this

Dimension : Month_Year

sum({<Month_Year={">$(=Date(AddMonths(max(Month_Year) ,-6),'YYYYMM'))<=$(=Date(AddMonths(max(Month_Year) ,0),'YYYYMM'))"},Year=,Month=>}Sales)

kavita25
Partner - Specialist
Partner - Specialist
Author

I have two date fields, on the basis of Sale date Month year, it should show last 6 month on the basis of Order Date Month Year.

sasikanth
Master
Master

Please do share your app or sample data

kavita25
Partner - Specialist
Partner - Specialist
Author

PFA where salesposted date is for Jun, so I want data for Jun,Jul,Aug Sep, Oct Nov & Dec of Travel Date.

kavita25
Partner - Specialist
Partner - Specialist
Author

Please Help me with this issue...

sasikanth
Master
Master

HI,

try to post the Full data , attachment have only two Dates nothing more than that

Please come up with sample application

kavita25
Partner - Specialist
Partner - Specialist
Author

I want on the basis of two dates only and count of 3rd coilumn.

Sales date is for Jun-2015 and Next 3 months should be for Jun-2015 to Dec 2015.(Travel Date)