Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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.