Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
mrbqlik2009
New Contributor III

listbox filtering remove after reload

Hi,

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:

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, SaleTypeTitle

    ADMIN, USER1, 123456, 'test1'

    ADMIN, USER1, 123456, 'test2'

    USER, USER2, 123456, 'test3'

];

Section Application;

when i login for example with user1, in listbox show 'test1' and 'test2'.

but when i reload document, all value of listbox is appear.

5 Replies

Re: listbox filtering remove after reload

Try this?

Load * Inline [

SaleTypeTitle

test1

test2

test3

test4

test5

];


Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, SaleTypeTitle

    USER, USER1, 123456, test1

    USER, USER1, 123456, test2

    USER, USER2, 123456, test3

];

Section Application;


And, This option need to be enabled Document Properties -> Opening tab -> and "select Initial Data Reduction based on Section Access"

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
vishsaggi
Esteemed Contributor III

Re: listbox filtering remove after reload

One way of doing this is like below:

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, SALETYPETITLE

    ADMIN, USER1, 123456, 'TEST1'

    ADMIN, USER1, 123456, 'TEST2'

    USER, USER2, 123456, 'TEST3'

];

Section Application;

FORCE Case Upper;

LOAD * INLINE [

SaleTypeTitle

test1

test2

test3

];

And make sure you have this check enabled

Capture.PNG

mrbqlik2009
New Contributor III

Re: listbox filtering remove after reload

Thank you.

but SaleTypeTitle come from database not inline

vishsaggi
Esteemed Contributor III

Re: listbox filtering remove after reload

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

FROM tablename;

MVP & Luminary
MVP & Luminary

Re: listbox filtering remove after reload

After reload it is expected behavior that all data will appear.  Data reduction occurs only when a document is opened.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

http://www.easyqlik.com