Qlik Sense Drill down staying in same level when there is only one value

[sayanpwc]

Qlik Sense Drill down staying in same level when there is only one value. I have one geography hierarchy where first level is Area,then Region and territory. so when In Area if we have one value it should automatically go to next level. but it is starting from Area only with one value.

Any idea?

[micheledenardi]

Try to Add null() values per each dimension of your Drill down:

Concatenate(YourGeographicalMasterDataTable)
Load
null() as Area,
null() as Region,
null() as Territory
Autogenerate(1);