Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can I make Authentication in Qlikview

We have lots of departmant in our firm. I make qlikview report for my firm. All reports are in the same web pages. I want to show report to depatmant only about them. When they login the system they only see the reports about them. How can I make this?

5 Replies
Not applicable
Author

hi

i think you make authentication from this code, write in your script and then try it

SECTION Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD

    ADMIN, test1, password

    USER, test2, password

];

Section Application;

Not applicable
Author

Dear,

you can apply sheet level or object level security.

1) sheet level security.----->

                                         right click on the sheet ------->goto general Tab----->select the Radio button Conditional

          write the if condition

like =if(Osuser()='AAA',1)

thanks,

mukram.

Not applicable
Author

But when i do Section Access, All reports are shown in web pages. When they click reports, see the userid and password is obliged. I want to show reports that only about them. They will see the reports aboout their department only. Not the others.

And the second things about section access, When I do this, I take erros when loading in QVMC. How can I prevent this

Not applicable
Author

hi

Go to Document Properties->Go to the Opening tab->Uncheck Initial data reduction based on section access .

Hope it help.

Dont forget to save and then open the application.

You can also see if User Properties->"Remember login credential until qlikview exists " is checked in General tab

thanks

Not applicable
Author

thank you very much for your answer. I did as you said. But in that time it does not make data reduction that I describe in section access. Is there any adjustment for this..