Skip to content

Instantly share code, notes, and snippets.

@mikeharding

mikeharding/SetAnalysis.qvs

Last active April 1, 2019 21:36
Show Gist options
  • Save mikeharding/ddc6004b302f82fb03e7 to your computer and use it in GitHub Desktop.
Save mikeharding/ddc6004b302f82fb03e7 to your computer and use it in GitHub Desktop.
Download ZIP
Commonly used Qlik set analysis expressions.
Raw
SetAnalysis.qvs
// Sum of last year Sales
Sum({$<Year = {$(=Max(Year)-1)}>} Sales)
// Sum of Sales for year = 2013
Sum({<Year = {2013}> Sales}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment