topic Re: Filter selection based on user login in QlikView

Filter selection based on user login

Wed, 04 Jun 2014 08:31:25 GMT

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

Re: Filter selection based on user login

tresB — Wed, 04 Jun 2014 08:36:41 GMT

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

Re: Filter selection based on user login

amit_saini — Wed, 04 Jun 2014 08:44:09 GMT

Hi Tribhuwan,

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

Thanks,

Re: Filter selection based on user login

amit_saini — Wed, 04 Jun 2014 08:47:20 GMT

Also please use:

Username: admin

Password: admin

Thanks,

Re: Filter selection based on user login

hic — Wed, 04 Jun 2014 09:00:52 GMT

For Section Access, see http://community.qlik.com/blogs/qlikviewdesignblog/2014/05/26/section-access

HIC

Re: Filter selection based on user login

Wed, 04 Jun 2014 09:26:21 GMT

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

Re: Filter selection based on user login

amit_saini — Wed, 04 Jun 2014 09:33:20 GMT

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,

Re: Filter selection based on user login

maxgro — Wed, 04 Jun 2014 09:36:08 GMT

section access

Re: Filter selection based on user login

Wed, 04 Jun 2014 09:39:26 GMT

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