Set analysis working fine with qlikview and not working with sense

[diegomyd83]

Hello, we recently moved from view to sense. I created a table with this formula

sum({$ <
[Registration year] ={"<=$(Previous Year)"},
[Type] = {"Pat"},
[Code] = [Code] - {"CHB","APB"},
[Level 5] = [Level 5] - {"999"}
>}
[Value])

This works pefectly in view but gives 0 in sense. the problem seems to be  

[Registration year] ={"<=$(Previous Year)"},

even if I change it into 

[Registration year] ={"<=2022"},

it seems not working. 

What am I doing wrong? 

Thank you in advance for your help!

[vincent_ardiet_]

Weird...
And is it working with [Registration year] ={2022} ?

[diegomyd83]

If I change it into

[Registration year] ={'=2022'},

it gives a result (not sure if correct)

adding < it stops working

[Adam_Romanowski · Accepted solution]

It looks like field [Registration year] isn't interpreted as date or number.

[diegomyd83]

any idea on how i can force it? 

[Adam_Romanowski]

In script:

num#([Registration year]) as [Registration year]