Total function?

[qlikuser222]

Hi Everyone,

I have  requirement where the results in starlight table should respect only date but ignore all.

PFA which exlapins requirement clearly. Can you please help me to solve it?

Thanks

[sunny_talwar · Accepted solution]

Try this

Sum(TOTAL {1<Year = $::Year>} Value)

Also, look here

Ignore all selections except some specific fields using Set Analysis