topic Re: Section Access in QlikView in QlikView

Section Access in QlikView

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

Hi All,

I would like to apply the section access in qlikview.

The requirement is different user with different data with specific prefix letter

Access	UserID	Password	FIELD
ADMIN	A	1234	*
USER	B	1234	HK*
USER	B	1234	ABC
USER	C	1234	CN*

How to apply the section access like HK*?

User B will able to access the data with prefix letter HK and ABC

User C will able to access the data with prefix letter CN.

Best Regards,

Louis

Re: Section Access in QlikView

Anonymous — Tue, 14 Feb 2017 07:10:23 GMT

Any idea on it?

Re: Section Access in QlikView

Anil_Babu_Samineni — Tue, 14 Feb 2017 07:22:47 GMT

May be try thi

Column level access using Section Access

Re: Section Access in QlikView

Anonymous — Tue, 14 Feb 2017 08:04:30 GMT

Hi Anil,

Thank you for reply.

The post you shared is for column level security.

Seems is different with my case.

Best Regards,

Louis

Re: Section Access in QlikView

Anonymous — Tue, 14 Feb 2017 08:26:17 GMT

Any idea on it?

Re: Section Access in QlikView

devarasu07 — Tue, 14 Feb 2017 08:29:39 GMT

Hi,

Try this,

row level security, how to?

Type of Security

Also refer my sample attachment,

SECTION Access;

LOAD * INLINE [

COUNTRY, USERID,PASSWORD,ACCESS

INDIA, DEVA,ADMIN123,USER

SINGAPORE, RAM,ADMIN123,USER

*,ADMIN,ADMIN45,ADMIN

];

SECTION Application;

Fact:

LOAD * INLINE [

COUNTRY, SALES

INDIA, 1000

SINGAPORE, 2000

MALAYSIA, 3000

INDONESIA, 5000

];

Hope this helps

Regards,

Deva

Re: Section Access in QlikView

vardhancse — Tue, 14 Feb 2017 09:59:07 GMT

Requirement was not with define data I guess

What ever country starts with IN* all countries the user should be able to see.

Re: Section Access in QlikView

Anonymous — Tue, 14 Feb 2017 12:03:17 GMT

Hi,

Please find attached the app.

I think this is what you need.

Best regards,

Cosmina