When I bring my data this are my fields that brings date data
Date#(Fecha,'DDMMYYYY') As FechaNum,
YEAR(Fecha) As Anio,
MONTH(Fecha) As Mes,
Where Fecha is my field containing dates in dd/mm/yyyy format
From your script above, it doesn't seem like Fecha is in dd/mm/yyyy format, it seems to be in ddmmyyyy meanding 31012015 instead of 31/01/2015. Which of the two is right???
QlikView and Qlik Sense should have same Set Analysis syntax I believe (not an expert in Qlik Sense)
I know, but if Fecha is DD/MM/YYYY then FechaNum will not be calculated properly.
You will need this for FechaNum:
Num(Date#(Fecha, 'DD/MM/YYYY')) AS FechaNum
and just so Fecha is read properly, try doing this:
Date(Date#(Fecha, 'DD/MM/YYYY')) as Fecha
See if that helps, if not what is the expression you are trying to use?