topic Re: Using Match() & OSUser() with an Excel File in QlikView

Using Match() & OSUser() with an Excel File

microwin88x — Thu, 27 Mar 2014 17:50:59 GMT

Hello!

I have my application where there is a Table that has the following fields:

Client (Dimension)
Category (Dimension)
#Attentions (Expression)

Each Client belongs to a particular Office where he works. That Office is a Field in my QlikView application.

Today I got a Excel file with a list of Users that should have access to the Table depending on the Office they have assigned.

For example, the file has the following columns:

Office	User
Office1	User1
Office2	User2
Office3	User3

So the User1 should only see the information in the Table for the Clients that work in the Office1.

The application has also many other objects which they will be visible for all the users. So I only want to filter for that Table.

Do you have any idea of how could I do this?

1. Should I load the Excel file in my app?

2. I need to apply the filter only in the Table. But should I apply it over the Dimension CLIENTS or in the Expression #ATTENTIONS? Because I don't want a User to see the CLIENTS from other Offices.

3. I was told that I could use the functions Match() & OSUser(). How could I do this?

Thank you!!!

Re: Using Match() & OSUser() with an Excel File

its_anandrjs — Thu, 27 Mar 2014 17:58:45 GMT

Hi,

Use sheet level section access security in your application and give access to the user depends on the department wise to the user so he can see only that department data.

Hope this helps

Thanks & Regards

Re: Using Match() & OSUser() with an Excel File

microwin88x — Thu, 27 Mar 2014 18:01:32 GMT

Yes, but I want that all the Users see all the information in the application except for that particular table... In the other objects they could see the information for other Offices.

Re: Using Match() & OSUser() with an Excel File

its_anandrjs — Thu, 27 Mar 2014 18:13:35 GMT

Yes you can do this with section access also and create a different users like Admin and Normal user and give access according to the type of user.

Hope this helps

Thanks & Regards