topic Re: listbox filtering remove after reload in QlikView

listbox filtering remove after reload

mrbqlik2009 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: listbox filtering remove after reload

Anil_Babu_Samineni — Mon, 08 Oct 2018 15:10:11 GMT

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"

Re: listbox filtering remove after reload

vishsaggi — Mon, 08 Oct 2018 15:20:33 GMT

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

Re: listbox filtering remove after reload

mrbqlik2009 — Mon, 08 Oct 2018 15:29:17 GMT

Thank you.

but SaleTypeTitle come from database not inline

Re: listbox filtering remove after reload

vishsaggi — Mon, 08 Oct 2018 15:38:06 GMT

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;

Re: listbox filtering remove after reload

rwunderlich — Mon, 08 Oct 2018 17:24:03 GMT

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