topic Drill-down problem in QlikView

Drill-down problem

Anonymous — Mon, 22 Feb 2010 13:45:26 GMT

Hi guys,

I usually experience this strange drill-down behavior of Qlikview: if the drill-down operation results in only one available value, it is skipped and drill-down continues on the lower levels.

Examples are in screenshots:

This is the initial situation. There this this group TIME which includes all the time related fields starting from YEAR and finishing with SECOND:

When I click on the year 2008 Qlikview does a normal drill-down and obviously moves down to the MONTH level:

But, if instead of 2008 I choose 2007 where I have only 3 values in total what I get is this:

As you can see Qlikview skips all the levels where there is only one available element to show. So, the first level where 2 elements are found is HOUR. And this is where the drill-down stops. There is no way I can see the MONTH level on the chart if 2007 is selected.

Am I missing something? Are there solutions?

Thanks!

Valera

Drill-down problem

Mon, 22 Feb 2010 15:00:04 GMT

Maybe a stupid question - but is the sort order right (Year -> Month -> Day -> Hour)?

If yes, could you post your application and I'll have a look.

Drill-down problem

Anonymous — Mon, 22 Feb 2010 15:17:36 GMT

The order is right Year - Month - Day...

Take a look at the application. I would appreciate any suggestions. 🙂

Thanks.

Valera

Drill-down problem

Mon, 22 Feb 2010 15:28:38 GMT

Hi Valera,

When a drill-down group is used as a dimension in a chart, the chart will use the first field 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, provided that it has more than one possible value. If no field in the list has more than one possible value, the last field will be used anyway.

That´s like QlikView behave.

Good luck!

Rainer

Drill-down problem

Anonymous — Mon, 22 Feb 2010 15:34:47 GMT

Thanks Rainer,

so, by this you mean that what I consider an anomaly is actually the natural Qlikview's behavior? 🙂

Well then, I guess I need to find a workaround... 😕

Drill-down problem

Wed, 03 Mar 2010 20:21:46 GMT

Did you find a workaround for this issue??? I'm having a very similar problem...

Thank you

Drill-down problem

Anonymous — Wed, 03 Mar 2010 21:04:17 GMT

Nope, no nice workaround except of showing explicitly in separate boxes the drill-down field values.

As you can see on the attached screenshots above I put the list boxes with the fields which participate in the drill-down group.

Maybe there is a way to solve this problem with macro - this is still to discover.

Drill-down problem

rwunderlich — Wed, 03 Mar 2010 21:39:50 GMT

The workaround I've seen on the Forum is to add a null value to each category to make sure you always have "more than one".

I would attach an example but the file attachment upload seems to have stopped working.

-Rob

Drill-down problem

Anonymous — Wed, 03 Mar 2010 21:42:48 GMT

A NULL value sounds fine. I guess I will take this as a good workaround. 🙂

Thanks.

Drill-down problem

Wed, 31 Mar 2010 20:09:04 GMT

Looks like this issue is fixed in version 9

Re: Drill-down problem

Mon, 28 Jan 2013 17:06:39 GMT

Hi, do you know if this was ever resolved. I am having the same issue in version 11. I have only one available value that I want to summarize on but give the user the option to drill down to the accounts making up this value.

Because there is only one value that is summarised on, it is skipping and drill down is showing the lowest level, so 2,500 accounts. Which is not of much use.

thanks

Pete

Re: Drill-down problem

FranAgraz — Tue, 27 Oct 2020 19:21:30 GMT

Hi Rainer!

What could I do to prevent this from happening?

Thank you very much

Francisco