listbox filtering remove after reload

[mrbqlik2009]

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.

[Anil_Babu_Samineni]

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"

[vishsaggi]

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

[mrbqlik2009]

Thank you.

but SaleTypeTitle come from database not inline

[vishsaggi]

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;

[rwunderlich]

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