topic Re: Re: Drill Down in QlikView

Drill Down

Fri, 14 Nov 2014 09:11:48 GMT

Please can someone send me an example of how to do a drill down.

Thanks.

Re: Drill Down

sushil353 — Fri, 14 Nov 2014 09:24:05 GMT

check out below:

http://coummunity.qlik.com/thread/48358

HTH

sushil

Re: Drill Down

jpenuliar — Fri, 14 Nov 2014 10:36:30 GMT

Hi Gerald,

have a look at link:

there are plenty of questions similar to yours you can search i the community

Re: Drill Down

Fri, 14 Nov 2014 12:03:09 GMT

Thanks Jonathan,

So I have created the group,made the selections for dimensions, and added it as my dimension.

Why does nothing happen when I click on the arrow?

Re: Drill Down

arulsettu — Fri, 14 Nov 2014 12:12:07 GMT

post some screen shot

Re: Re: Drill Down

Fri, 14 Nov 2014 12:19:05 GMT

Attached is the relevant qvd

Re: Drill Down

jonathandienst — Fri, 14 Nov 2014 12:21:15 GMT

Gerald Britt wrote:

So I have created the group,made the selections for dimensions, and added it as my dimension.

Why does nothing happen when I click on the arrow?

You drill down by making a selection on the field in the drill down group. That expands the dimension to the values of the second level matching the selection. Click the up arrow to back out of the drill down.

The drill groups often contain something like, Year, Month, Day. Click in a year and it will expand to the matching months. Click on a month and it will expand to the days matching the year and month selection. Go back by clicking the icon.

HTH

Jonathan

Re: Drill Down

jpenuliar — Fri, 14 Nov 2014 12:22:35 GMT

The top field of your Drill down is Campaign, so no action on the arrow to go up as it is at the top drill.

if you click on the rows of campaign, it will drill down to DealNo.

then you can click on arrow to go up

Re: Re: Drill Down

Fri, 14 Nov 2014 12:26:18 GMT

Eish. you see. it works. Thanks everyone.