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

sayanpwc — Mon, 20 Dec 2021 21:08:46 GMT

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?

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

micheledenardi — Wed, 27 Jan 2021 11:09:51 GMT

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);

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

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

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