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
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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: 
venkat1
Creator II
Creator II
‎2019-07-26 01:52 AM

Re: How do you use the document analyzer application (Version 1.5.0)

=IF(YM.YEAR_1=2017,'2016-17',
IF(YM.YEAR_1=2018,'2017-18',
IF( YM.YEAR_1=2019,'2018-19',
IF(YM.YEAR_1=2020,'2019-20',
IF(YM.YEAR_1=2021,'2020-21',
IF(YM.YEAR_1=2022,'2021-22',

)
)
)
)
)
)

or you can use pic match function also.

635 Views
0 Likes
2 Replies
jeck876
Contributor
Contributor
‎2019-07-26 02:50 PM

This seems to be posted on the wrong thread

613 Views
0 Likes
Sue_Macaluso
Community Manager
Community Manager
‎2019-07-30 08:14 AM

@venkat1 what product are you using? 

Did you find a solution to your question? Mark the solution as accepted : and if you found it useful, press the like button!
583 Views
0 Likes