Filter Not Working on visuals

[Nay]

Good day All

My Data field format is "DD-MM-YYYY ", i wrote in the below code on Qlik to split Month and Year into additional fields for filtering my visuals, however the filter is not working on the newly created fields but works on the original Date field only.

select
datepart(year,Date) as Year,
datepart(month,Date) as Month,
datepart(day,Date) as day

From
Table Name

[Mark_Little · Accepted solution]

I do not believe Dartpart is a function in Qlik and even if it is this will have created a data island, it would not be connect to the data model.

Need Something like

LOAD

Date,

YEAR(Date) as Year

...

Resident ...

[Nay]

Thank you, worked perfectly 🙂