topic Re: Problem with Complex Section access implementation . Help Needed !! in QlikView

Problem with Complex Section access implementation . Help Needed !!

shekhar_analyti — Wed, 21 Jun 2017 16:10:07 GMT

Hi All ,

Attached is sample qvw and data .

Here is my requirement .

1) Each Store has its manager and manager's employee ID .

So if a manager of particular country logins into application then he/she should have access of "Store Manager" sheet with his data only

2) Country head should have access to All the sheet but data of only its county and all the stores under his country .

3) Sales Manager should have access to Sales sheet

4) Hr Manager should have access to HR sheet only

Note : USERID is Mnager Name and Password is employee ID of manager .

I tried but It did not work properly with below code

Re: Problem with Complex Section access implementation . Help Needed !!

oscar_ortiz — Wed, 21 Jun 2017 17:07:38 GMT

You should have a look at this post Basics for complex authorization from hic‌.

Good luck

Oscar

Re: Problem with Complex Section access implementation . Help Needed !!

shekhar_analyti — Wed, 28 Jun 2017 07:34:07 GMT

stalwar1‌

Need your help Bhai !!

Re: Problem with Complex Section access implementation . Help Needed !!

jmvilaplanap — Wed, 28 Jun 2017 14:29:03 GMT

Hi,

I think that the easiest way is hide the tabrow for all users and design a menu with buttons that will be hide or not depending the section access.

For example you can create a table with user groups and then with the function "Only" create a condition to show each button.

Regards

Re: Problem with Complex Section access implementation . Help Needed !!

shekhar_analyti — Mon, 24 Jul 2017 07:01:07 GMT

antoniotiman‌

Re: Problem with Complex Section access implementation . Help Needed !!

antoniotiman — Mon, 24 Jul 2017 08:02:23 GMT

Hi,

You change in script

from Store To STORE

and From Country To COUNTRY.

And I also suggest You to add ADMIN User.

See Attachment (partially changed).

Regards,

Antonio

Re: Problem with Complex Section access implementation . Help Needed !!

antoniotiman — Mon, 24 Jul 2017 08:04:42 GMT

And in Document Property -> Open

Re: Problem with Complex Section access implementation . Help Needed !!

antoniotiman — Mon, 24 Jul 2017 09:55:34 GMT

It is a bit complex, as You haven't Upper Values in the Field STORE e COUNTRY.

See Attachment.

Re: Problem with Complex Section access implementation . Help Needed !!

shekhar_analyti — Mon, 24 Jul 2017 13:08:59 GMT

Hi Antonio ,

It seems that something not working correctly . Please find detailed screenshot .

Thanks & Regards

Shekar

Re: Problem with Complex Section access implementation . Help Needed !!

antoniotiman — Mon, 24 Jul 2017 13:42:55 GMT

HI,

Ypu wrote

Upper(Pick(Match(Left(Store,2),'De','GB','In','Ru'),'German','United Kingdom','India','Russia')) as COUNTRY

and STORE for Keriv Bojo is *

Can I get Emp_ID ?

Re: Problem with Complex Section access implementation . Help Needed !!

shekhar_analyti — Mon, 24 Jul 2017 15:49:40 GMT

Hi Antonio ,

Thanks for highlighting that . But i am confused now .

Actually STORE for Keriv Bojo should be all the stores under Germany i.e De . And its Emp_ID is DE10099 .

I thought data reduction will take care of "*" in above case and will automatically consider all stores under it .

Lets assume that there is no such sheet called user profile . USERID is Name of Mangers and PASSWORD is its store numbers .

And we have to build section access using datasheet from different countries and Country Head and DP Head.xlsx .

How to revamp the whole Section Access ?

Thanks & Regards

Shekar

Re: Problem with Complex Section access implementation . Help Needed !!

antoniotiman — Mon, 24 Jul 2017 16:07:49 GMT

Why

"STORE for Keriv Bojo should be all the stores under Germany i.e De " ?

STORE for Keriv Bojo is '*' and isn't possible get COUNTRY because Country comes from STORE field (other USER).

Can I get Country from Emp_Id field -> left(Emp_Id,2) (only for ACCESS ADMIN) ?

If Yes Then See Attachment.

Re: Problem with Complex Section access implementation . Help Needed !!

shekhar_analyti — Mon, 24 Jul 2017 17:11:24 GMT

This is something what i wanted and was struggling with for some time .
But only thing is that you , used User Profile sheet which i created for my own use . Actually Instead of User Profile

sheet , Country Head and DP Head sheet was to be used to achieve above result where

Sales	KL Kapoor	IN100171
Hr	Kaite Bakeson	RU100121

KL Kapoor could only access HR Sales sheet of app and Kaite Bakeson could only access HR sheet of app , along with above mentioned functionality that you have is your last attachment .

Thank You Very Much for helping me so far .

Re: Problem with Complex Section access implementation . Help Needed !!

antoniotiman — Mon, 24 Jul 2017 18:06:54 GMT

KL Kapoor -> sheet Sales

Kaite Bakenson -> sheet HR

and sheets Country Head and Store Manager ?

See Attachment

Re: Problem with Complex Section access implementation . Help Needed !!

shekhar_analyti — Tue, 25 Jul 2017 11:22:33 GMT

Thanks Antonio for reply

I guess the last attached qvw is not accepting Manager User IDs example - Keriv Bojo

KL Kapoor being sales head should have only access to sheet sales of all country not Just India .

Similarly Kaite should have only access to HR sheet and all the data irrespective of her country .

Re: Problem with Complex Section access implementation . Help Needed !!

antoniotiman — Tue, 25 Jul 2017 11:46:36 GMT

HI,

I'm sorry, I don't understand.

What is Your final expected result about all USERID,ADMIN,KL Kapoor and Kaite ?

Re: Problem with Complex Section access implementation . Help Needed !!

shekhar_analyti — Thu, 27 Jul 2017 07:56:29 GMT

Hi Antonio ,

Sorry for delayed response .

So I will now give my requirement from scratch .

Need a build section access where

1) Country heads will have access to all sheets of the application , having data relevant to their country .

2) DP (Department Head) should have access to respective sheet .

Example - KL Kapoor is Sales Head . He should have access to only Sales sheet of application with data of all countries . Note: Though he is from India , still he being sales head should have access to all the data in sales sheet, irrespective of country . Same Goes for HR head Kaite Bakeson.

3) Each store has store manager . So each store manager should have access to all the sheet with data of their own stores

Note : We have to use data sheet of all countries and data sheet with name country head and dp head . Please ignore user profile sheet (as I created it by copy pasting USER Name and password)

In order to achieve this functionality in a single application , do we have to revamp whole load script again ?

Thanks & Regards

Shekar

Re: Problem with Complex Section access implementation . Help Needed !!

shekhar_analyti — Fri, 28 Jul 2017 08:06:46 GMT

Hi Antonio ,

Any thoughts in requirement . Let me know i am not able to make myself clear .

Thanks & Regards

Shekar

Re: Problem with Complex Section access implementation . Help Needed !!

antoniotiman — Fri, 28 Jul 2017 08:19:31 GMT

Who are Country Heads and Department Heads ?

Can You provide new file User_profile ?

Re: Problem with Complex Section access implementation . Help Needed !!

shekhar_analyti — Fri, 28 Jul 2017 08:34:40 GMT

PFA ...