Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Authentication & Authorization

Hi

I new toi QlikViw,

  • What is the difference between Authentication & Authorization in QlikView? And how to implement them?

  • Thank in advaance
  • venu
1 Solution

Accepted Solutions
4 Replies
Miguel_Angel_Baeyens

Hi Venu,

Basically, authentication answers to the question "can you get to the QlikView Server?". QlikView does not authenticate but relies on the OS or security directory to do that.

If the answer is yes, you can get to the QlikView Server, then Authorization comes to place to answer the question "once I'm in the QlikView Server, what documents can I see?". Authorization is done as well by the security directory (LDAP, NTFS, etc.) and set by the QlikView Distribution Service (namely Publisher) in the distribution tasks.

Miguel

jagan
Luminary Alumni
Luminary Alumni

Hi Venu,

Authentication means giving access to the dashboard for the right people, for example the Sales Dashboard can be viewed only by Sales Department people only, Authentication is done at Dashboard level.

Authorization means giving access to the specific data in the Dashboard, for example the Revenue Dashboard, Sales data can be seen only by Sales Deparment and Employee data is only seen by HR Deparment.  This is called Authorization.

You can implement Authentication and Authorization in Qlikivew by using Section analysis concepts, check for this in Community and Qlikview Help file.  There are lot of examples.

Try this script

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.

Hope this helps you.

Regards,

Jagan.

Not applicable
Author

Hi Miguel,

I am struggling with the following query. Could you please help on this.

The application can move in different trays in the workflow. Each tray has different State_Codes.  e.g. Tray = NSS has State_code RDY, RUN & CMP in the following example. But each tray would have RDY (shows application came in a tray) and CMP (application completed in a tray). How can I get that how many working hours each application stayed in each tray. Working days are Monday to Friday and working hours are 9:00-17:00. There is also a problem that the application can go in each tray once or more than once as two examples below.

Once example: In this example application moved in each tray only once.

Application_idTraysTxn_DateState_Code
10007344NBG18/09/2013 12:33CMP
10007344NBG18/09/2013 12:33RDY
10007344NSS18/09/2013 16:23RDY
10007344NSS19/09/2013 09:05RUN
10007344NSS19/09/2013 09:07CMP
10007344CJA19/09/2013 09:07RDY
10007344CJA19/09/2013 09:11CMP
10007344NCO19/09/2013 09:11RDY
10007344NCO19/09/2013 09:20RUN
10007344NCO19/09/2013 09:20CMP
10007344NFU25/09/2013 08:28RDY
10007344NFU25/09/2013 08:28RUN
10007344NFU25/09/2013 08:28CMP
10007344NCH25/09/2013 08:28RDY
10007344NCH25/09/2013 11:56RUN
10007344NCH25/09/2013 12:02CMP
10007344NBO25/09/2013 12:02RDY
10007344NBO25/09/2013 12:03RUN
10007344NBO25/09/2013 12:07CMP
10007344NCA25/09/2013 12:07CMP
10007344NCA25/09/2013 12:07RDY

More than Once example: Application moved into NSA twice, CJA three times etc.

Application_idTrayTxn_DateState_Code
10007616NBG12/09/2013 10:42:29CMP
10007616NBG12/09/2013 10:42:29RDY
10007616NSA12/09/2013 10:42:29RDY
10007616NSA12/09/2013 11:25:55RUN
10007616NSA12/09/2013 11:26:33CMP
10007616CJA12/09/2013 11:26:33RDY
10007616CJA12/09/2013 11:27:24CMP
10007616NCO12/09/2013 11:27:24RDY
10007616NCO12/09/2013 12:56:32RUN
10007616NCO12/09/2013 13:00:24CMP
10007616NSA12/09/2013 13:00:24RDY
10007616NSA13/09/2013 16:20:38RUN
10007616NSA13/09/2013 16:22:08CMP
10007616CJA13/09/2013 16:22:08RDY
10007616CJA13/09/2013 16:25:47CMP
10007616NCO13/09/2013 16:25:47RDY
10007616NCO13/09/2013 16:50:57RUN
10007616NCO13/09/2013 16:51:47RDY
10007616NCO16/09/2013 10:42:22RUN
10007616NCO16/09/2013 10:43:00CMP
10007616NFU16/09/2013 10:43:00SUS
10007616NFU24/09/2013 08:31:02RDY
10007616NFU24/09/2013 08:31:02RUN
10007616NFU24/09/2013 08:31:05CMP
10007616NCH24/09/2013 08:31:05RDY
10007616NCH24/09/2013 12:13:58RUN
10007616NCH24/09/2013 12:15:25CMP
10007616NBO24/09/2013 12:15:25RDY
10007616NBO24/09/2013 12:15:26RUN
10007616NBO24/09/2013 12:16:01RDY
10007616NBO24/09/2013 12:16:04RUN
10007616NBO24/09/2013 12:16:05EXP
10007616NCH24/09/2013 12:16:05RDY
10007616NCH24/09/2013 13:25:26RUN
10007616NCH24/09/2013 13:26:20CMP
10007616NRD24/09/2013 13:26:20RDY
10007616NRD24/09/2013 15:30:05RUN
10007616NRD24/09/2013 15:30:07EXP
10007616NCH24/09/2013 15:30:07RDY
10007616NCH24/09/2013 15:30:08RUN
10007616NCH24/09/2013 15:31:42CMP
10007616NBO24/09/2013 15:31:42RDY
10007616NBO24/09/2013 15:31:43RUN
10007616NBO24/09/2013 15:37:25RDY
10007616NBO24/09/2013 15:37:27RUN
10007616NBO24/09/2013 15:37:32EXP
10007616NSA24/09/2013 15:37:32RDY
10007616NSA24/09/2013 15:39:51RUN
10007616NSA24/09/2013 15:41:37CMP
10007616CJA24/09/2013 15:41:37RDY
10007616CJA24/09/2013 15:43:42CMP
10007616NCO24/09/2013 15:43:42RDY
10007616NCO24/09/2013 15:52:46RUN
10007616NCO24/09/2013 15:53:44CMP
10007616NFU24/09/2013 15:53:44SUS
10007616NFU24/09/2013 15:53:47RDY
10007616NFU24/09/2013 15:53:47RUN
10007616NFU24/09/2013 15:54:06CMP
10007616NCH24/09/2013 15:54:06RDY
10007616NCH24/09/2013 15:54:08RUN
10007616NCH24/09/2013 15:54:12CMP
10007616NBO24/09/2013 15:54:12RDY
10007616NBO24/09/2013 15:54:14RUN
10007616NBO24/09/2013 15:55:56CMP
10007616NCA24/09/2013 15:55:56CMP
10007616NCA24/09/2013 15:55:56RDY