Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Read about Qlik’s Response to COVID-19 Read the Letter, Join the Group.
Highlighted
Valued Contributor II

Scenario

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

2 Replies
Highlighted
Highlighted
MVP & Luminary
MVP & Luminary

Re: Scenario

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.