Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Irvin182
Contributor II
Contributor II

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

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.

SA_-_ADMIN_View.JPG

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..

SA_-_USER1_View.JPG

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

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

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.

View solution in original post

1 Reply
Miguel_Angel_Baeyens

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.