Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show only months before or equal to selected month

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!

5 Replies
sunny_talwar

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

Not applicable
Author

This in Qlikview.

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

Anonymous
Not applicable
Author

Anonymous
Not applicable
Author

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)