Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
AIShatiLove
Contributor III
Contributor III

filter before filter

hi, Qlik 
i need to add to filter year where year >= 2020 : 
i wrote:  Year( {<Year([date]) >= {'2020'} >} [date])  - but Qlik says that i have error ')' 
field date  in format  DD.MM.YYYY

Labels (2)
1 Solution

Accepted Solutions
NitinK7
Specialist
Specialist

Try below exp

=if(Year(Date#([Date],'DD.MM.YYYY'))>=2020,Year(Date#([Date],'DD.MM.YYYY')))

View solution in original post

3 Replies
NitinK7
Specialist
Specialist

Try below exp

=if(Year(Date#([Date],'DD.MM.YYYY'))>=2020,Year(Date#([Date],'DD.MM.YYYY')))

AIShatiLove
Contributor III
Contributor III
Author

thank you, can you explain why your solution works, there is another expression:
  if(Year([Date])>=2020,Year([Date]))? What so special in Date# func ?

NitinK7
Specialist
Specialist

Qliksense Default date format is  MM/DD/YYYY, and your date format is DD.MM.YYYY

So you need to first read your date format using date#() function and then find out year.