Qlikview new Column with count of another column in 3 range

[#1]

aaa
10
9
5
7
21
25
27
51

i want to get another column say BBB

as

bbb
4
3
1

this count of

aaa<=10

aaa>10 and aaa<=30

aaa>30

how can we get this

[#2]

interval match can be used:

use this script

Inline_table:

LOAD * Inline [

from, to, aaa_Range

, 10, <=10

11, 30, >10 and <=30

31, , >30

];

table_1:

load

     aaa

from table1;

Left join(table_1)

Intervalmatch(aaa)

LOAD from, to

RESIDENT Inline_table;

Left join (table_1)

LOAD * resident Inline_table;

drop table Inline_table;

drop fields from, to from table1;

left join(table_1) // do not join of you want result in another table, if you join then bbb will be repeated

load

     aaa_Range,

     count(aaa_Range) as bbb

resident table_1

group by aaa_Range;