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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filter selection based on user login

Hi Guys,

I have a requirement where I have to display the data based on user login.

I have 3 users in my application user1 ,user2 ,user3

I want to build my application in such a way that every user first login and then see the dashboard which contains data for only that user.

My plan is to put a list box which will have users and once a user logged in that value would be selected in list box. By this way logged in user will be able to see only relevant data.

I am using section access to create user/password and then using document properties--> triggers-->onopen--> select in field-->

and comparing list box field with QVUser().

Kindly guide me is it the right approach to achieve this or suggest alternate approach.

Tribhuwan

Labels (1)
8 Replies
tresB
Champion III
Champion III

If you use section access, trigger would not be required. Because, with section access, user1 would only see user1 in the list box.

amit_saini
Master III
Master III

Hi Tribhuwan,

This can be done my section access, please see the attachment.

Thanks,

AS

amit_saini
Master III
Master III

Also please use:

Username: admin

Password: admin

Thanks,

AS

hic
Former Employee
Former Employee

Not applicable
Author

Hi Amit,

Thanks for your quick response and this app.

My requirement is if user u1 is login then chart should show sales data for u1 and when u2 is login then sales data for u2 only.

Both user will have different login id and password

suppose u1 : u1/password

             u2 : u2/password

Tribhuwan

amit_saini
Master III
Master III

Hi ,

You can do one thing here suppose you want to share Chart A with user1 then goto to chart properties and under condition write this:

OSUser() = 'TIC\User1'

Similarly you can give this condition in other charts for OSUser() = 'TIC\User2'

Thanks,

AS

maxgro
MVP
MVP

section access

Not applicable
Author

Hi

My requirement is not like user u1 should see chart1 and user u2 should chart2.

I have only one chart suppose that sales vs region. If user u1 is login then this chart should display sales for u1 only and simalrly for u2.

Please lemme know if my explanation is clear.

Tribhuwan