Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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)