Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try below exp
=if(Year(Date#([Date],'DD.MM.YYYY'))>=2020,Year(Date#([Date],'DD.MM.YYYY')))
Try below exp
=if(Year(Date#([Date],'DD.MM.YYYY'))>=2020,Year(Date#([Date],'DD.MM.YYYY')))
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 ?
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.