why the formula does not works?

[Alonal148]

Hi,

I am new with Qlik Sense.

I would like to filter the measure "Total Energy Satec" BY Year = 2018

I have tried the follow formulas, but no one is working:

Sum({$<Year={"2018"}>} Total Energy Satec)

Sum({$<Year={'2018'}>} Total Energy Satec)

Sum({$<Year={'2018'}>} [Total Energy Satec])

Sum({$<Year={2018}>} [Total Energy Satec])

I also Tried to filter the measure by another dimention, but it is not working. 

Please advise.

Thank you,

Alona

[Qlik1_User1]

try this

Sum({$<Year={"2018"}>} [Total Energy Satec])

[Alonal148 · Accepted solution]

Thank you,

I got help from another forum.

the correct formula is:

Sum({$<[Date.Year]={"2018"}>} [Total Energy Satec])

[Qlik1_User1]

if you got the resolution, please mark the solution as correct.