Discussion board where members can get started with QlikView.
I have listbox with 5 item 'test1', 'test2', 'test3', 'test4' , 'test5'.
i have 2 user in section access 'user1', 'user2'.
I define section access this:
LOAD * INLINE [
ACCESS, USERID, PASSWORD, SaleTypeTitle
ADMIN, USER1, 123456, 'test1'
ADMIN, USER1, 123456, 'test2'
USER, USER2, 123456, 'test3'
when i login for example with user1, in listbox show 'test1' and 'test2'.
but when i reload document, all value of listbox is appear.
Load * Inline [
USER, USER1, 123456, test1
USER, USER1, 123456, test2
USER, USER2, 123456, test3
And, This option need to be enabled Document Properties -> Opening tab -> and "select Initial Data Reduction based on Section Access"
One way of doing this is like below:
ACCESS, USERID, PASSWORD, SALETYPETITLE
ADMIN, USER1, 123456, 'TEST1'
ADMIN, USER1, 123456, 'TEST2'
USER, USER2, 123456, 'TEST3'
FORCE Case Upper;
And make sure you have this check enabled
but SaleTypeTitle come from database not inline
Yes, we do not know that so just gave an example. So if this field is coming from database just try like
LOAD *, Upper(SaleTypeTitle) AS SALETYPETITLE;
SQL Select yourfieldlist
After reload it is expected behavior that all data will appear. Data reduction occurs only when a document is opened.