Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
sayanpwc
Partner
Partner

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

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?

1 Reply
micheledenardi
Specialist II
Specialist II

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);
Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.