topic Re: I notice in drill down it is bypassing one level of hierarchy. in QlikView

I notice in drill down it is bypassing one level of hierarchy.

Fri, 20 Sep 2013 11:04:54 GMT

Hi Team

I notice in drill down it is bypassing one level of hierarchy.

For example:

I have the data with hierarchy Year->Half Year->Quarter->Month.

I created Drill down group “TimePeriod” with hierarchy level (Year->Half Year->Quarter->Month)

When I click on the drill down from Half Year it directly goes to Month instead of Quarter.

Observation: I notice this is specific case when we have single vales at the hierarchy level,

In this case I have one quarter-(Q3) data for Half Year- 2013-H2, when I click on the Half Year drill it directly goes to Month.

Such As

2013-H1 Drill goes to (Q1/ Q2)

2013-H2 Drill directly goes to Month.

Thank you.

Re: I notice in drill down it is bypassing one level of hierarchy.

yevgeniy — Fri, 20 Sep 2013 11:34:26 GMT

Hi,,

I don't can load your sample.

May be problem in sequence field sequence.

Open your group and check sequence UsedField

Re: I notice in drill down it is bypassing one level of hierarchy.

Fri, 20 Sep 2013 18:12:48 GMT

Thanks for Reply Yevgeniy Popov,

Attached is the document with the qvw file.

Re: I notice in drill down it is bypassing one level of hierarchy.

Carlos_Reyes — Fri, 20 Sep 2013 21:46:48 GMT

That's the default behavior for DrillDown Groups.

Re: I notice in drill down it is bypassing one level of hierarchy.

Sat, 21 Sep 2013 06:24:20 GMT

Hi,

In drill down for a single value it automatically go to the next level of hierarchy. To show the quarter it must have more than one value

Re: I notice in drill down it is bypassing one level of hierarchy.

yevgeniy — Mon, 23 Sep 2013 08:24:53 GMT

Hi, Satish

I load qvw file, but i don't can open this document.

May be need choose Half Year_1 and will be Q1, Q2,

HailfYear_2 and will be Q3,Q,4.

If you choose some values in the top group, will be switch to the child elements of the group, and so on to the bottom element.

Re: I notice in drill down it is bypassing one level of hierarchy.

yevgeniy — Mon, 23 Sep 2013 09:46:38 GMT

Carlos rights, that's the default behavior for DrillDown Groups.

This may be problem in field sequence.

Promote or Demote you field

Re: I notice in drill down it is bypassing one level of hierarchy.

yevgeniy — Mon, 23 Sep 2013 10:04:19 GMT

Hi, Satish

I understand you.

The same situation is with me in 2013 year.

HailfYear_2 not have child elements Q3, Q4 .

When will the Oct to be Q3, Q4

Its ok

Re: I notice in drill down it is bypassing one level of hierarchy.

Mon, 23 Sep 2013 10:13:13 GMT

Hi Amuthabharathi Subramanian, can you shed ome more light on this?

Re: I notice in drill down it is bypassing one level of hierarchy.

jagan — Mon, 23 Sep 2013 10:14:39 GMT

Hi,

If there is one value then qlikview automatically skips one level. It is the default behaviour.

Regards,

Jagan.

Re: I notice in drill down it is bypassing one level of hierarchy.

Mon, 23 Sep 2013 13:50:43 GMT

Hi All, thanks for reply, it the default behavior . But my bat I need to show the values even if it have single value.

Re: I notice in drill down it is bypassing one level of hierarchy.

jagan — Mon, 23 Sep 2013 14:25:03 GMT

Hi Satish,

You can do it manually by using dynamic dimension like this

If(GetSelectedCount(Quarter) > 0, Month,

If(GetSelectedCount(HalfYear) > 0, Quarter,

If(GetSelectedCount(Year) > 0, HalfYear, Year)))

Hope this helps you.

Regards,

Jagan.

Re: I notice in drill down it is bypassing one level of hierarchy.

Tue, 24 Sep 2013 06:34:03 GMT

Thanks Jagan, I will try dynamic dimension but not sure how to incorporate this in the drill down.

Re: I notice in drill down it is bypassing one level of hierarchy.

jagan — Tue, 24 Sep 2013 06:51:55 GMT

Hi Satish,

There is no need of Drilldown, in place of DrillDown column just use this Dynamic Dimension.

Regards,

Jagan.

Re: I notice in drill down it is bypassing one level of hierarchy.

yevgeniy — Tue, 24 Sep 2013 07:30:21 GMT

Hi Satish,

You can do reload calendar 2013 year end.

Other data reload today.

May be it will help.