Skip to content

Instantly share code, notes, and snippets.

@ralfbecher

ralfbecher/QlikView_Calculate_Age_Group.qvs

Last active December 15, 2015 19:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save ralfbecher/5314212 to your computer and use it in GitHub Desktop.
Save ralfbecher/5314212 to your computer and use it in GitHub Desktop.
Download ZIP
Calculate age-group in QlikView
Raw
QlikView_Calculate_Age_Group.qvs
LOAD
if(age<16, 'Under 16',
if(age>65, 'Over 65',
text(16+(Div(age-16,10)*10)) & ' - ' & text(25+(Div(age-16,10)*10)))) as age_group
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment