Conditional Calculation

[qlikviewaf]

Hi,

i have a table that i would like to calculate only if YEAR is not selected.

Which is the right syntax?

Thanks!

[tresesco]

If(not getselectedcount(YEAR), <expression>)

Update: ohh,, you wanted otherwise (corrected adding a 'not')

[sunny_talwar]

You might also be able to do this in your expression

If(GetSelectedCount(YEAR) = 0,....)

Or use this in chart's calculation condition like this

GetSelectedCount(YEAR) = 0