Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
amijit_hazarika
Contributor III
Contributor III

Default to previous year but enable user to select from a year from dropdown list as well

Hi Qlik Enthusiast,

 

I have a "Year" Column which has Year from 2015-2019. The requirement is;

 

Need a filter pane. Till 31st March 2019, the default year should show as 2018. However if the user clicks on the drop down, he/she should see 2015,2016,2017,2018 and 2019. 

Now, from 1st of April 2019, it should show 2019 as default year and others on the drop down. 

Any input of how to achieve this in the most effective way would be very helpful. 

 

Thanks

Amijit

4 Replies
Ivan_Bozov
Luminary
Luminary

Hi, you need a fiscal calendar. There are a lot of topics here, e.g. this one: https://community.qlik.com/t5/QlikView-Documents/Fiscal-and-Standard-Calendar-generation/ta-p/148082...

vizmind.eu
pradosh_thakur
Master II
Master II

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Others have responded with fiscal calendars, but I understand your question is about how to make default selections, correct?

 

-Rob

amijit_hazarika
Contributor III
Contributor III
Author

That's right.