How to restrict my data in the filter object

[bhanu99]

The following is a example data 

Channel	folder	subfolder
US	MAIN	JRM
US	IMP	UIO
US	SEMI	POK
GLOBAL	MAIN	MOP
GLOBAL	IMP	JIL
GLOBAL	SEMI	ENT
CH	MAIN	LUK
CH	IMP	AVU
CH	SEMI	PLI

I need to have two filters in my sheet, first filter should have values channel (just the field name), MAIN and SEMI. For this i created a inline code :

Load *
Inline
[
Filterdim,dimID
Channel,1
MAIN,2
SEMI,3
];

now my second filter has to be dependent on my first filter . if 'Channel' is choosed in my first filter i should get values of my channel column and if MAIN is selected then the respective values in subfolder (JRM,MOP,LUK) should come in my second filter , same goes for SEMI. how to achieve this

[edwin]

the qlik data model takes care of that for you:

[bhanu99]

my first filter is 'channel''MAIN' and 'SEMI'.

If i select ' channel' then US,GLOBAL,CH should come in second filter. if i select 'MAIN ' then JRM,MOP,LUK in the second