Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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.



14 Replies
yevgeniy
Creator
Creator

Hi,,

I don't can load your sample.

May be problem in sequence field sequence.

Open your group and check sequence UsedField

Not applicable
Author

Thanks for Reply Yevgeniy Popov,

Attached is the document with the qvw file.

Carlos_Reyes
Partner - Specialist
Partner - Specialist

That's the default behavior for DrillDown Groups.

Not applicable
Author

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

yevgeniy
Creator
Creator

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.

yevgeniy
Creator
Creator

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

This may be problem in field  sequence.

Promote or Demote you field

yevgeniy
Creator
Creator

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

Not applicable
Author

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

jagan
Luminary Alumni
Luminary Alumni

Hi,

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

Regards,

Jagan.