Set Default View based on Most Recent Year

[#1]

Hello,

In my example qvw file, it shows the Year from 2007 to 2015. When I open up the qvw, the current default view is match the current Year range.

How if I only want to show the most recent 3 years in the default view without manually set up condition for year = 2013, 2014 and 2015?  Becuse I could have year, 2016, 2017, 2018 ... ... in the future. Is there a way to set up the defalt view with only the most recent year in listbox. By the same time, I would like to show previous years as options/selection for users.

Thanks in advance,

Becky

[#2]

It shows :

[sunny_talwar]

Try this:

If(Submit_Year >= Max(TOTAL Submit_Year) - 3, Submit_Year)

[#4]

Yeah, this works. Thanks Sunny!

But it somehow shows a Null year value...

[sunny_talwar]

Select 'Suppress When Value is Null' on the dimension tab for your dimension

[#6]

Awesome! All set!

[#7]

This search string doesn't seem to work for me for similar usage. My field is [COB Date]

I am pulling last 15 days data and want to default open on most recent date.

The data looks like this - 17/08/2016 00:00:00

[#8]

Have you try to use floor() function to convert your date from Timestamp format to Date format?

[#9]

Didn't work. Tried with Getdate()-1 in searchstring also.