You need to use intervalmatch functionality :
load * inline
Load * inline
[Start, End, Description
Load distinct Start, End Resident Interval;
interval.qvw 157.0 K
Thanks for your answer massimo.
What if my name name colum contains 10000 records?
I was thinking of building a chart referencing the table and for each bar of the chart make a formula without using alternative table,
i will write it in natural language as i am not sure of the qlikview
so i wanna see the number of people on the vertical axis
on the horizontal the bar with the number of people under 7 years for example
so for this write something like
if age under 7 then count the number of people and display it : i would label it <7 years
if age between 7 and 15 then count number of people etc...
I am just not sure that your solution is adaptable to my scale of people, or is it?
you can manage with class function and if as already posted (in the attachment 10000 different names)
you can also calculate every bar with an expression (last sheet in the attachment)
aageclass (1).qvw 349.2 K