Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Luminary
Luminary

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

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...

Highlighted
Master II
Master II

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

Highlighted
MVP & Luminary
MVP & Luminary

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

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

 

-Rob

Highlighted
Contributor III
Contributor III

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

That's right.