Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thank you,
I got help from another forum.
the correct formula is:
Sum({$<[Date.Year]={"2018"}>} [Total Energy Satec])
try this
Sum({$<Year={"2018"}>} [Total Energy Satec])
Thank you,
I got help from another forum.
the correct formula is:
Sum({$<[Date.Year]={"2018"}>} [Total Energy Satec])
if you got the resolution, please mark the solution as correct.