Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

qlikviewaf
New Contributor III

Conditional Calculation

Hi,

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

Which is the right syntax?

Thanks!

2 Replies
MVP
MVP

Re: Conditional Calculation

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

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

MVP
MVP

Re: Conditional Calculation

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

Community Browser