back to qlikblog.at

Set Analysis Examples - Ad Hoc Expressions

These examples use Ad Hoc Expressions within a Set Analysis Expressions (marked red).

Sum of Sales based on the current selection, but calculate only Sales in the last/current year.

Sum({$<Year={$(=max(Year))}>}Sales)

Open Wizard

Return Sum of Sales only for the year before the maximum year.

Sum({$<Year={$(=Max(Year)-1)}>}Sales)

Open Wizard