Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try:
If(Max(YearField) = Year(Today()), Sum(condition1), Sum(condition2))
JG
try below
If(getfieldselection(year) = Year(Today()), Sum(condition1), Sum(condition2))
Thanks Juan. I´m trying it now.
Thanks Nitink7.
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.