topic Re: filter before filter in App Development

filter before filter

AIShatiLove — Fri, 12 Mar 2021 07:49:38 GMT

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

Re: filter before filter

NitinK7 — Fri, 12 Mar 2021 08:04:39 GMT

Try below exp

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

Re: filter before filter

AIShatiLove — Fri, 12 Mar 2021 08:20:25 GMT

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 ?

Re: filter before filter

NitinK7 — Fri, 12 Mar 2021 08:27:55 GMT

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.