Having trouble on Section Access should show all data even if it's 0

[Irvin182]

Hi everyone, I'm having a data problem with Section Access. I  have a summary table which has Indicator_level as Dimension which has 1-4 category and that has expression of Number of customer and Total MSF. Upon login to ADMIN the summary shows everything even there is no data for INDICATOR LEVEL=2.

But upon login to USER1 that has INDUSTRY as GAMING but has no INDICATOR LEVEL "2" on the data list, INDICATOR LEVEL"2" went missing even i declare "COUNT({1}distinct ID)" hidden below TOTAL MSF..

Need to show all INDICATOR LEVEL even with missing indicator. Thanks in advance.

here's the script:

Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, INDUSTRY
ADMIN, ADMIN, ADMIN, *
USER, USER1, USER1, GAMING
USER, USER2, USER2, STRATEGIC
];
Section Application;
TransactionTable:
LOAD * INLINE [
INDUSTRY, ID, MSF, INDICATOR
GAMING, 1, 23453, 4
GAMING, 2, 4535345, 1
GAMING, 3, 89, 4
GAMING, 4, 45353, 1
GAMING, 5, 7898, 1
GAMING, 6, 76867, 1
GAMING, 7, 79, 3
GAMING, 8, 45745, 1
GAMING, 9, 457, 3
GAMING, 10, 123, 3
GAMING, 11, 253, 1
GAMING, 12, 1623, 1
STRATEGIC, 13, 13231, 2
STRATEGIC, 14, 355, 3
STRATEGIC, 15, 34535, 3
STRATEGIC, 16, 345, 3
STRATEGIC, 17, 345345, 3
STRATEGIC, 18, 89, 1
STRATEGIC, 19, 876, 2
STRATEGIC, 20, 8908, 1
STRATEGIC, 21, 3456, 3
STRATEGIC, 22, 7897, 2
STRATEGIC, 23, 7989, 3
STRATEGIC, 24, 978, 2
STRATEGIC, 25, 4567, 3
STRATEGIC, 26, 1233453, 3
STRATEGIC, 27, 16345, 4
STRATEGIC, 28, 655, 4
];

Indicator_Table:
LOAD * INLINE [
INDICATOR_LEVEL,INDICATOR
1, 1
2, 2
3, 3
4, 4
];

[Miguel_Angel_Baeyens · Accepted solution]

Short answer is: it is working as expected.

A bit longer answer is: section access works in a very similar way to when you open the app with full data on QlikView Desktop, then make the selection in the fields as in the section access table, and then go to File > Reduce Data > Keep possible values, or in other words, the data is completely removed from the user. And that's why 2 does not show up, because for that user is not even in their data model.

That means that you will need to create a value with INDICATOR = 2, even if it's empty, on your data model, and include INDICATOR 2 on the section access table for USER1.