Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
qlikviewaf
Contributor

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')

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