topic Re: How made invisible list ? in QlikView

How made invisible list ?

Fri, 13 Dec 2013 06:35:59 GMT

Hi all!

I have logins admin,user1 and user2. Have list1 and list 2. How i can made list2 inviseble for user1?

it not work

and =if(qvUser()='USER1',False(),True()) not work

Re: How made invisible list ?

tresB — Fri, 13 Dec 2013 06:51:36 GMT

Could please post your sample app?

Re: How made invisible list ?

Anonymous — Fri, 13 Dec 2013 06:54:48 GMT

Hi Kons,

try this in edit script

Load * Inline [

ACCESS, USERID, PASSWORD, USERTYPE

ADMIN, ADMIN, ADMIN, *

USER, USER1, U1, USER1

USER, USER2, U2, USER2

];

section application;

Load * Inline [

USERTYPE

USER1

USER2

];

after that at list 1 conditional type:

=Match('USER1',$(=CONCAT(CHR(39)&REGION&CHR(39),',')))

at list 2 conditional type:

=Match('USER2',$(=CONCAT(CHR(39)&REGION&CHR(39),',')))

hope it can handle what you need

Regards,

Re: How made invisible list ?

Fri, 13 Dec 2013 08:28:44 GMT

Load * Inline [

ACCESS, USERID, PASSWORD, TOID

ADMIN, ADMIN, ADMIN

USER, USER1, U1, 3

USER, USER2, U2

];

section application;

Re: How made invisible list ?

Fri, 13 Dec 2013 08:31:08 GMT

if in type list 1=0 - it must be invisible, BUT I see it

Re: How made invisible list ?

michael_maeuser — Fri, 13 Dec 2013 08:35:28 GMT

did you make sure that you have the correct osuser and if there´s domain you need that too? is suggest create a textbox with =osuser() to make sure you write it exactly that way. also in the condition put your username in '', s.th. like that

=osuser()<>'user1'

Re: How made invisible list ?

michael_maeuser — Fri, 13 Dec 2013 08:36:56 GMT

oh and make sure you have at least two sheets. and for testing first save the qvw and then open it with user1

Re: How made invisible list ?

Anonymous — Fri, 13 Dec 2013 08:43:17 GMT

Load * Inline [

ACCESS, USERID, PASSWORD, TOID

ADMIN, ADMIN, ADMIN, *

USER, USER1, U1, 3

USER, USER2, U2, 2

];

section application;

then in list 1 conditional type

=Match('2',$(=CONCAT(CHR(39)&REGION&CHR(39),',')))

it should be done and for sure to have sheet more than 1 so you can see the different

Re: How made invisible list ?

tresB — Fri, 13 Dec 2013 08:54:01 GMT

See the attachment, try to login with user2, and then admin. Make sure that you don't save your application when in user mode. You can restrict that in the doc settings-> security-> save doc (uncheck); admin override sec (check)

Re: How made invisible list ?

Fri, 13 Dec 2013 09:07:12 GMT

Hi Konstantin

Is the security for displaying all sheets and objects is disabled ?

regards

Chris

Re: How made invisible list ?

Fri, 13 Dec 2013 09:07:38 GMT

but it not work for list

Re: How made invisible list ?

Fri, 13 Dec 2013 09:09:24 GMT

=osuser()<>'USER1' not work

Re: Re: How made invisible list ?

tresB — Fri, 13 Dec 2013 09:26:33 GMT

It works. PFA

Re: Re: How made invisible list ?

Anonymous — Fri, 13 Dec 2013 09:32:42 GMT

Is it the list you really need?

Re: How made invisible list ?

Fri, 13 Dec 2013 09:42:14 GMT

yes. In test.qwv only main list. need main list and list...not main and made it invisible. i cand made it becouse i can't use type. i can made invisible text, table ... but not list...

Re: Re: How made invisible list ?

Anonymous — Fri, 13 Dec 2013 09:49:14 GMT

here i update the .qvw hope this is what you need

Re: How made invisible list ?

Fri, 13 Dec 2013 10:19:49 GMT

thx! my hero