topic Age bands in QlikView

Age bands

Sun, 16 Dec 2012 13:27:11 GMT

Hi all,

Age in group on x axis?

I could manage to calculate age and represent in chart.

X axis - age in 10, 11, 12... 25... etc.

Y axis - total coubt of patients.

Created a variable

vAgeCal = date (interval(patient arrival date - date of birth), 'YY')

I would like the x axis to be

10-15 16-20 20-25 instead of 10, 11,12..., 25

I am pretty new to qv. It would be great if anyone can help.

Thanks.

K.v

Re: Age bands

Or — Sun, 16 Dec 2012 13:50:22 GMT

You'll be wanting to use the Class() function.

Class(Age,5,'x',10) should be what you're looking for in this specific case, I think.

Re: Age bands

Sun, 16 Dec 2012 14:31:30 GMT

Doesnt work. Might be I am writing the expression wrong.

Class(vAgeCal, 10, '10-20, 20) is what gave as an expression.

Is it correct? It does reload though.

Re: Age bands

Or — Sun, 16 Dec 2012 14:51:54 GMT

That does not look correct. The expression as I wrote it is what you should be using (replacing your age column with "Age"). I prefer to use it directly in a calculated dimension, rather than in the script (I think it works either way, though). If you want to understand exactly how Class() works, just look it up in the help file.

Re: Age bands

Sun, 16 Dec 2012 23:29:21 GMT

Resolved it by using an if condition in the load script.