Qlik Sense Drill Down Functionality skips to next level for single value Field upon Section Access

[PradeepLti]

Hello,

I am trying to create a Drill down where First column will have only single value followed by next dimensions having multiple values.

1st FieldName: Division value - GLOBAL

2nd FieldName: REGION - 7 Values for REGION

3rd FieldName: COUNTRY - Multiple values

Hence to show the column Division as 1st column in dimensional Drill down, 

I concatenate null() as Division and appended it with the existing table.

It works fine but if I apply section access, it skips and moves automatically to 2nd Field - REGION.

Section Access is based on Region Level.

Any solution to achieve this  with section access ?

Thank you !

[udit_k]

Assign some Dummy value to Division , Region, Country for that null row.

In Section Access allow that Dummy row to be visible to all.

Section access;

Load * INLINE [

ACCESS, USERID, Region

USER, AD_DOMAIN\1, * 

DUMMY,DUMMY,DUMMY

];

Section Application;

LOAD * INLINE [

USER, Region, Country

1,USA, ABC,

1, USA, XYZ,

1, AUS, PQR

1, IND, FGH

1, USA, ERT

1,RSA, TYU

1, SL, FGG

1, BAN, ERT
DUMMY,DUMMY,DUMMY
];

[PradeepLti]

Hello,

Thank you for the response. 

But if I do the same, I will be getting DUMMY as a value in REGION field in the front end.

Thank you!

[udit_k]

Dummy Value is just for displaying data in drill  down on applying section access in script;

could try out if((USER)='Dummy','',USER) in drill down expression to hide Dummy data.