Drill Down

Sun, 17 May 2015 03:56:53 GMT

I have data for Region, Division, Territory. I want to create a drill down/ cyclic group. I have another list box with this group and I want to control the selection in such a way.

Territory	Division	Region	Sales	User
t1	d1	r1	100	u1
t2	d1	r1	200	u2
t3	d2	r1	300	u3
t4	d2	r1	400	u4

I want to show sale as measure.

Suppose territory is first level selected (currently t1 selected)

When I drill to next level i.e. division, It should be selected as d1 and value of sales should be coming 500.

Similarly when drill to region sales should be 1000 and value r1 should be selected.

What should be approach to implement it. Its really very critical. Please guide the correct way to do it

Re: Drill Down

awhitfield — Mon, 18 May 2015 15:23:43 GMT

Can you confirm the order of levels please?

Andy

topic Re: Drill Down in QlikView

Drill Down

Re: Drill Down