filter before filter

[AIShatiLove]

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

[NitinK7 · Accepted solution]

Try below exp

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

[AIShatiLove]

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]

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.