GetFieldSelections as Value

[Stars]

I'm trying to use GetFieldSelections to return a value and I can't figure out what I'm doing wrong.

When I write an equation that says:

Sum({1<Question={"Statistics*"},Year={'2010'}>}Response), Qlik understands what I'm saying.

When I write it like this, so Qlik would be finding the selected year:

Sum({1<Question={"Statistics*"},Year={getfieldselections(Year)}>}Response), Qlik doesn't recognize what I've selected.

How do I get my selected field (in this case, whatever year I'm choosing) to be recognized?  Thanks.

[MayilVahanan · Accepted solution]

Hi @Stars 

Try like below

Sum({1<Question={"Statistics*"},Year={$(=GetFieldSelections(Year))}>}Response)

or, if you want to get the max year , if there is no selection in Year

Sum({1<Question={"Statistics*"},Year={$(=max(Year))}>}Response)