Skip to content

Instantly share code, notes, and snippets.

@mountaindude

mountaindude/sense_set_sum_per_max_date

Last active October 24, 2017 09:56
Show Gist options
  • Save mountaindude/b5cde851f56a98962a1e to your computer and use it in GitHub Desktop.
Save mountaindude/b5cde851f56a98962a1e to your computer and use it in GitHub Desktop.
Download ZIP
QlikView / Sense set expression to pick the data for the last available date
Raw
sense_set_sum_per_max_date
// Sum FieldName per the last available date we have data for, withinin the current selection
Sum( {$<DateNum={$(#=Max(DateNum))}>} FieldName)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment