Calculate age-group in QlikView
| 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