Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. 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.