topic Re: Section Access with multiple fields Or condition in QlikView

Section Access with multiple fields Or condition

vardhancse — Fri, 26 Jun 2015 03:27:09 GMT

Hi,

Have a requirement is that

Have below data

Group	Country	GRM	Customer	Location	LRM
Group1	India	Name1	Customer1	India	Name1
Group1	India	Name1	Customer2	Singapore	Name2
Group1	India	Name1	Customer3	Australia	Name3
Group1	India	Name1	Customer4	China	Name4
Group2	Australia	Name3	Customer1	Singapore	Name2
Group2	Australia	Name3	Customer2	Australia	Name3
Group2	Australia	Name3	Customer3	China	Name4
Group2	Australia	Name3	Customer4	India	Name1

Now my section access should work like if a user login in to dashboard, he should be either GRM/LRM then then only he should see his relevant data.

Can please any one let me know the solution for the same, thanks in advance for your support.

PFA sample QVW

Re: Section Access with multiple fields Or condition

hariprasadqv — Fri, 26 Jun 2015 04:52:06 GMT

Hi,

In that case LRM and GRM names should be different.It is better to use ID's.

Thanks.

Re: Section Access with multiple fields Or condition

vardhancse — Fri, 26 Jun 2015 04:55:59 GMT

Hi,

The condition is that the login user to dashboard should see the data only for which he is either GRM & LRM, that is why we should have or condition

Re: Section Access with multiple fields Or condition

vardhancse — Fri, 26 Jun 2015 04:56:38 GMT

gwassenaar‌ jagan‌ Can please help me out

Re: Section Access with multiple fields Or condition

Fri, 26 Jun 2015 04:58:30 GMT

Hi,

first of all you will use upper case of fields, because section access will work only on upper case values.

Regards

Vimlesh

Re: Section Access with multiple fields Or condition

vardhancse — Fri, 26 Jun 2015 05:00:37 GMT

Hi thanks for your reply,

Yeah I know section access will work on upper case I tried merging both GRM and LRM using the condition like

UPPER(IF(len(trim(GRM))>0,GRM,'<ANY>') &'|'& IF(len(trim(LRM))>0,LRM,'<ANY>')) as AuthID

in fact table

Re: Section Access with multiple fields Or condition

Fri, 26 Jun 2015 05:06:17 GMT

Try this

Hope it helps

Re: Section Access with multiple fields Or condition

Fri, 26 Jun 2015 05:07:55 GMT

hi,

look at this app.

username - ram

password- ram

Regards

Vimlesh

Re: Section Access with multiple fields Or condition

Fri, 26 Jun 2015 05:09:32 GMT

Hi,

Why dont you load one table with user and countries he has access to.PFA

ADMIN1,ADMIN1

USER1,USER1

Re: Section Access with multiple fields Or condition

hariprasadqv — Fri, 26 Jun 2015 05:10:17 GMT

Hi,

1.As vimlesh20‌ said SECTION ACCESS elements shoud be in UPPER CASE.

2.Regarding your case. Either LRM or GRM they should be identified by a key value right, so use that key ion the section access tabel.

3.In the mapping tabel map the keys with their Role(GRM/LRM)

See the below prototype. It may help you

Ex:

Section Access Table:

USERID PASSWORD EMPID

A 1234 101

B 1234 102

C 1234 103

D 1234 104

E 1234 105

MAPPING TABLE:

EMPID POSITION LOCATION

101 GRM INDIA

102 LRM US

103 LRM UK

104 GRM UAE

105 LRM INDIA

Thanks

Re: Section Access with multiple fields Or condition

Fri, 26 Jun 2015 05:13:23 GMT

hi,

yes you can use

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, AUTHID

ADMIN,ram,ram,NAME1|NAME1

ADMIN,vimlesh,NAME2|NAME1

ADMIN,san,san,NAME1|NAME2

];

Section Application;

table:

LOAD GROUP,

COUNTRY,

GRM,

upper(Customer) as CUSTOMER,

upper(Location) as LOCATION,

upper(LRM) as LRM,

UPPER(IF(len(trim(GRM))>0,GRM,'<ANY>') &'|'& IF(len(trim(LRM))>0,LRM,'<ANY>')) as AUTHID

FROM

(ooxml, embedded labels, table is Sheet1);

Regards

Vimlesh

Re: Section Access with multiple fields Or condition

vardhancse — Fri, 26 Jun 2015 05:15:28 GMT

Hi,

Yes but in for limited set of combinations we can use but of large volume of data how can we go in manual approach

Re: Section Access with multiple fields Or condition

vardhancse — Fri, 26 Jun 2015 05:16:38 GMT

USER NAME AND PASSWORD PLEASE.?

Re: Section Access with multiple fields Or condition

vardhancse — Fri, 26 Jun 2015 05:17:58 GMT

Hi,

My requirement is not based on region and more over looking for solution with or condition between 2 fields

Re: Section Access with multiple fields Or condition

vardhancse — Fri, 26 Jun 2015 05:19:07 GMT

I am looking for or condition between GRM and LRM but not on country

Re: Section Access with multiple fields Or condition

jagan — Fri, 26 Jun 2015 06:39:12 GMT

Hi Sasi,

Is there any sample user details with sample LRM & GRM values? Please attach.

Regards,

jagan.

Re: Section Access with multiple fields Or condition

vardhancse — Fri, 26 Jun 2015 07:32:12 GMT

Hi Jagan,

PFA QVW for reference.

Re: Section Access with multiple fields Or condition

Fri, 26 Jun 2015 07:42:59 GMT

Hi jagan,

My client need to authenticate through gmail account and then pass access.

please help me.

i searched and got web ticking ,when i am using that code ,getting some error.

please tell me something how can i do.

Regards

Vimlesh

Re: Section Access with multiple fields Or condition

jagan — Fri, 26 Jun 2015 08:16:19 GMT

Hi,

Try like this using OMIT

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, OMIT

ADMIN,ADMIN1,ADMIN1, LRM

USER,USER1,USER1, GRM

USER,USER2,USER2, GRM

];

Section Application;

Now user ADMIN1, LRM column is hidden

Now user USER1, GRM column is hidden

Now user USER2, GRM column is hidden

Please find attached file.

Regards,

Jagan.