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

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

PradeepLti — Fri, 15 Nov 2024 21:37:48 GMT

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 — Fri, 30 Jun 2023 16:30:05 GMT

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 — Mon, 03 Jul 2023 03:21:07 GMT

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 — Mon, 03 Jul 2023 08:57:49 GMT

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.