If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
How do I create the syntax for:
An If statement that checks date for current year, like so:
If (year selected by filter = current year),
then --- Sum () statement 1,
else --- Sum() statement 2)
I don´t know how to write the condition part of this IF statement in parentheses, to check if selected year is current year.
If(Max(YearField) = Year(Today()), Sum(condition1), Sum(condition2))
If(getfieldselection(year) = Year(Today()), Sum(condition1), Sum(condition2))
Thanks Juan. I´m trying it now.
For the new QlikSense vocabulary with getfieldselection. I´ll try it out.
Thanks Juan. It works!
Thanks Nitink7. I just tried it and it worked.