How to create line chart without calendar to display past 3 months data including selected month?

[Ashley33]

Hello All 🙂

Based on the attached excel data which does not have a calendar, is it possible to display the above chart in QLiksense when the user selects the month = 10 and Year = 2018?

That is to display the Shipment data for the month of October and the past 2 months.

Also for example if the user selects the month = 1 and Year = 2018, then the chart must display data for the 3 months of November 2017, December 2017 and January 2018.

THanks in advance.

[Channa]

Bro you need date column if not add date column 

like start or end date of each month

then you can do 

=Sum({$<[Ship Date]={">=$(=MonthStart(Today(),-3))<$(=monthend(Today(),0))"}>}Sales)

[Ashley33]

Thank you for the proposition.

I tried to build a calendar as i have lots of shipment data. Please find the calendar excel attached.

is it possible to use the PeriodCounter in the expression? For example, 

only( {>=$(max(PeriodCounter) - 2) <$(max(PeriodCounter)}shipment)

where max(PeriodCounter) represents the selected month  and year in the qliksense application.

[Channa]

did you try Dimension Limit property 

[Ashley33]

im nnew to qliksense, can you please tell me how to do it?

[Channa]

under dimension you have this

it will not be valid if you showing all years because you will get 12 first

[Ashley33]

Hi again, Thank you for your comments but I'm sorry i dont understand.

Please find attached the application and also the source data. Can you please help me on it?