topic Re: Section Access control using flag in QlikView

Section Access control using flag

gauthamchilled — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Table1:

Customer,Country,Period,Publish

A,Germany,2005,1

B,Italy,2005,1

C,Iraq,2005,0

SectionAccess:

NTName,Access,Country,Period,Flag

Alfred,Admin,<ANY>,2005,1

Jerald,Admin,Iraq,2005,1

Jack,USer,Iraq,2005,0

My requirement is, i want Jerald to see 2005 related data for Iraq but Jack should not see it.

I wish to control it from the Table1 on field Publish.

If i make Publish column 1 then Jack and Jerald both should see it.

How can i achieve this?

In terms of business I want to release the data in the dashboard but Jerald see it first and once he approves over email

i will make publish column 1 so that Jack,Jerald or whoever have access to Iraq, irrespective of flag value either 0/1

should see it.

can anyone help?

Re: Section Access control using flag

Gysbert_Wassenaar — Sat, 25 Jun 2016 12:54:08 GMT

Try:

Section Access;

LOAD * INLINE [

NTNAME, ACCESS, COUNTRY, PERIOD, PUBLISH

Alfred,Admin,,2005,1

Jerald,Admin,Iraq,2005,1

Jack,USer,Iraq,2005,0

];

Section Application;

Table1:

LOAD * INLINE [

Customer,Country,Period,PUBLISH

A,Germany,2005,1

B,Italy,2005,1

C,Iraq,2005,0

];

Re: Section Access control using flag

Peter_Cammaert — Sat, 25 Jun 2016 19:23:38 GMT

Take into account that link field names (names of fields that cross the SectionAccess-SectionApplication border) should be in upper case, and that multi-field keys won't always produce the expected behavior (Section Access and synthetic keys like to fight). Except when those fields are in different tables.

Best,

Peter

Re: Section Access control using flag

gauthamchilled — Sun, 26 Jun 2016 01:20:20 GMT

Hi Gybert,

I did a small mistake in the example posted.

Actually I dont have period in the section access table. It is difficult to add all periods combination for all users.

What can i do in this case?

plz help

i just have

ntname,access,country..but table1 have country and period combination

Re: Section Access control using flag

Anil_Babu_Samineni — Sun, 26 Jun 2016 07:30:43 GMT

As Gysbert Continuation..

As per BRD, You can set the Access for diff users..

- Anil

Re: Section Access control using flag

gauthamchilled — Sun, 26 Jun 2016 08:45:01 GMT

Anil babu..

Can you please explain how?

Re: Section Access control using flag

gauthamchilled — Mon, 27 Jun 2016 02:33:50 GMT

Even i bring the period filed to section access,it not seems to work. Because flag field table 1 is the field that will be controlled.

Flag field on the section access is static. the publish field on the table1 is dynamic.

1 on publish filed will make all user of that country and period to see all data.

0 on publish filed will make the user to access who have 1 as flag in section access table.

can anyone help please?

Re: Section Access control using flag

gauthamchilled — Mon, 27 Jun 2016 05:33:12 GMT

Bump

Re: Section Access control using flag

Digvijay_Singh — Mon, 27 Jun 2016 07:09:14 GMT

What if you just keep Publish field common between 2 tables and play with Publish field in table 1 to decide what to display and what not, not sure though, see attached example, use JERALD, JACK in caps to login -

Re: Section Access control using flag

gauthamchilled — Mon, 27 Jun 2016 08:59:50 GMT

I know that way.. the requirement here is something like

If business release a year data for the country, whoever have the flag 1 is considered as managements people.

0 is considered as normal users.

First business user have to see the data for the new year release data, after the confirmation from them via email..we will make the flag 1..so that everyone can see the data.

Not sure how to implement the logic.

Re: Section Access control using flag

Digvijay_Singh — Mon, 27 Jun 2016 10:08:45 GMT

I think this way it may work -

1. Keep duplicate entries for Mgmt people having 0,1 both in Publish flag, like below -

Section Access;

LOAD * INLINE [

ACCESS,USERID,PUBLISH

ADMIN,ALFRED,1

ADMIN,JERALD,1

ADMIN,ALFRED,0

ADMIN,JERALD,0

USER,JACK,0

];

2. Now when new year data is published, keep flag value as 1, so that only Mgmt people can see the data, as below -

Section Application;

Table1:

LOAD * INLINE [

Customer,COUNTRY,Period,PUBLISH

A,Germany,2005,0

B,Italy,2005,0

C,Iraq,2005,0

D,Germany,2006,0

E,Italy,2006,0

F,Iraq,2006,0

G,Germany,2006,1

H,Italy,2006,1

I,Iraq,2006,1

];

3. When Mgmt guys are ok with the data change flag value to 0 so that both Mgmt and Users can see the data, as below -

Section Application;

Table1:

LOAD * INLINE [

Customer,COUNTRY,Period,PUBLISH

A,Germany,2005,0

B,Italy,2005,0

C,Iraq,2005,0

D,Germany,2006,0

E,Italy,2006,0

F,Iraq,2006,0

G,Germany,2006,0

H,Italy,2006,0

I,Iraq,2006,0

];

Re: Section Access control using flag

Digvijay_Singh — Mon, 27 Jun 2016 10:09:49 GMT

By mistake highlighted entries showing 2006, it should be 2007 to reflect new year.

Re: Section Access control using flag

gauthamchilled — Tue, 28 Jun 2016 02:47:10 GMT

Thanks,

But duplicate in section access wont cause access issue?

Re: Section Access control using flag

Digvijay_Singh — Tue, 28 Jun 2016 03:05:11 GMT

I don't think so, we are not changing credential, we are just providing additional data access.

Re: Section Access control using flag

Anil_Babu_Samineni — Thu, 30 Jun 2016 13:51:00 GMT

Gautham,

Did you solve the issue, If yes, Close this Thread Or else get a chance to look this

http://www.qknow.com.br/wiki/index.php/Section_Access_(English)

- Anil Chowdary