Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
F1992
Contributor II
Contributor II

Extract years from date and use it in the filtter

I have  dates attributes in excel sheets from 1483 to 2019  with the below format

2019-06--23 00:00:00.0000000.I want to filter my page using only years how can
I do that ?

Labels (1)
4 Replies
Taoufiq_Zarra

Hi @F1992 

normally this script will help you :

Year(Date#([Your_Date], 'YYYY-MM-DD hh:mm:ss.0000000')) as Year

 

if this is not the case share here an example of your input data and what you want as output

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
F1992
Contributor II
Contributor II
Author

Here are my dates sample I want to show  1438,2000,2001......until 2019 in the filter

 
 
Taoufiq_Zarra

can share your sample data in usable format: Excel,csv,...

the expected output is a list like this is

Capture.PNG

or do you want to concatenate years like that :1438,2000,2001 ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Anil_Babu_Samineni

Try this?

Load Year(Date#(Left(Field, 4))) as Year, Field From Table;

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful