Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
It would be much more easier to help if you can provide a sample to work with
This in Qlikview.
I do not want everthing after March being visible, because it makes no sense.
Try to modify your expression with month <=max(month) like if you have set analysis:
sum({<month={'<=max(month)'}>}Sales)
May be something like this adjustment in your formula
Sum({$<Date={">=$(=Date(MonthStart(Max(Date),-2)))<=$(=Date(Max(Date)))"} >} Sales)