Show only months before or equal to selected month

[#1]

Hi all,

I have a table with all months visible on top and years 2016, 2015 and 2014 visible on the left side.

When I select the current month of March, all months stay visible, because of my expression being like Month = .

The issue is, I only want the months visible previous to the current one + the current month. How can I manage this in my expression?

So basically, If I select March, I only want to see January, February and March.

I have to make the calculation: sales 2016 - sales 2015 and of course everting after March is waaaay below zero. I do not want this being visible.

Thanks in advance!

[sunny_talwar]

It would be much more easier to help if you can provide a sample to work with

[#3]

This in Qlikview.

I do not want everthing after March being visible, because it makes no sense.

[Anonymous]

Did you check this?

Set Analysis for certain Point in Time

Set Analysis for Rolling Periods

[Anonymous]

Try to modify your expression with month <=max(month) like if you have set analysis:

sum({<month={'<=max(month)'}>}Sales)

[Digvijay_Singh]

May be something like this adjustment in your formula

Sum({$<Date={">=$(=Date(MonthStart(Max(Date),-2)))<=$(=Date(Max(Date)))"} >} Sales)