topic Re: Account Drill Down in QlikView

Account Drill Down

Mon, 28 Jan 2013 12:46:40 GMT

Hi,

I have a drill down to show me a specific client name and when clicked drill down into accounts of this client.

In my report, at the moment this is the only client so it automatically is showing account level instead of grouping it at summary level, so it is showing thousands of accounts instead of the summary even though client name is specified as the highest level of the drill down.

Is there a way of showing this at a summary level even though there is only 1 client?

many thanks

Re: Account Drill Down

Mon, 28 Jan 2013 16:46:51 GMT

How many drill down levels you've got?

Re: Account Drill Down

Mon, 28 Jan 2013 16:48:01 GMT

only one drill down, do you have any idea why it is forcing it down to account level?

Re: Account Drill Down

christian77 — Mon, 28 Jan 2013 16:56:21 GMT

Because that's the way it works.

A drill group goes down everytime you filter a value of any level.

That's way I use most of the times the cyclic one. I can filter and be at the level that I want.

Drill down always goes down, or up if you don't filter.

In fact, I use drill down groups only if after my explanation, the client want's to have it anyway.

bye.

Re: Account Drill Down

Mon, 28 Jan 2013 17:15:00 GMT

I can't believe that this is the way it works

the issue is that I'm not actually drilling down. It is automatically showing the lowest level just because there is only one available dimension. If I add a null dimension it will show a summary that I can click to drill down.

I would like in my dimension to show this as a summary and if you click then you drill down to the accounts making this up. It is showing around 2,500 accounts instead of the summary that I would like.

From looking at other forum postings like this it appears to be a Qliview issue, rather than the way it should work. It shouldn't be drilling down because there happens to be only one dimension, it looks like I need to work around it.

bye

Re: Account Drill Down

christian77 — Mon, 28 Jan 2013 17:19:50 GMT

Well, it is another way, that I never use.

Is the answer correct?

Re: Account Drill Down

Mon, 28 Jan 2013 17:21:58 GMT

You've got any listbox with Your drill-down chart dimensions?

Re: Account Drill Down

rwunderlich — Mon, 28 Jan 2013 18:46:23 GMT

I don't think it's fair to descibe this as a QV "issue". It is working the way QV designed and documented it. From the Help:

"When a drill-down group is used as a dimension in a chart, the chart will use the first Fields in the group's list of fields that has more than one possible value. If selections are made that cause the field to have only one possible value, the next field in the list will be used instead..."

So it's working as designed and the workaround is to add a null to make sure there are two values. In your app it may not be the design you would like, but there are just as many cases where the current design is an advantage.

-Rob

Re: Account Drill Down

Tue, 29 Jan 2013 13:47:48 GMT

cheers Rob, I understand- it's just a bit frustrating to have to work around it