topic Re: Scenario in QlikView

Scenario

abhaysingh — Mon, 24 Nov 2014 05:44:06 GMT

Hello Guys,

i need your help in One Scenario,

i have developed the QV application in an xyz organization and employee can access in a DOMAIN,

what i want is my 2000 dealer can see their own data, e.g.

ex- i am abhay(dealer) can access XYZ organization QV Application from outside the network, and data must be relevant to Abhay(Dealer) only like my sales, outstanding etc.

how can it be possible ???

please suggest something..

regards

abhay

Re: Scenario

sujeetsingh — Mon, 24 Nov 2014 05:47:54 GMT

SECTION ACCESS

http://community.qlik.com/blogs/qlikviewdesignblog/2014/05/26/section-access

Introduction to Section Access

QlikView Section Access Examples

Re: Scenario

jagan — Mon, 24 Nov 2014 06:43:27 GMT

Hi,

Check this sample script using section access

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, REDUCTION

ADMIN, Admin, password, *

USER, Sales, password1, 1

USER, Market, password1, 2

];

Section Application;

star is *;

Departments:

LOAD * INLINE [

REDUCTION, Dept,

1, Sales

2, Marketing];

Sales:

LOAD * INLINE [

Dept, Sales

Sales, 100

Sales, 200

Sales, 4646

Sales, 755

Sales, 422

Sales, 42

Marketing, 2

Marketing, 453

Marketing, 54

Marketing, 45

];

When you login as Admin, you can see all data in the dashboard, when you login as Sales then you can see only Sales data and when you login as Market you can see only Marketing data.

User and password details for this application is

User Name Password

Admin, password

Sales, password1

Market, password1

Note: You need to select Document Properties -> Opening tab -> and select Initial Data Reduction based on Section Access option

Hope this helps you.

Regards,

Jagan.