Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
knightwriter
Creator III
Creator III
‎2015-07-16 05:35 AM

Range of dates / years

    Hi all,

I have a chart and it shows years from 2005 to 2020, how do I narrow this down to show only 2015 or 2015-2020

I have tried =year(competition. start date) = '2015' and it does not work. Appreciate any help.

Thank you

1,081 Views
0 Likes
10 Replies
knightwriter
Creator III
Creator III
‎2015-07-16 07:08 AM
Author

In response to jagan

Thank you all for you comments and ideas, it is much appreciated. I used =If(Year([Opportunity.Anticipated Close Date]) >= 2015, Year([Opportunity.Anticipated Close Date]))

102 Views