Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I new toi QlikViw,
Hi Venu,
Hope this link will help you:
http://community.qlik.com/blogs/qlikviewdesignblog/2014/01/07/authentication-and-authorization
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
Hi Venu,
Hope this link will help you:
http://community.qlik.com/blogs/qlikviewdesignblog/2014/01/07/authentication-and-authorization
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.
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_id | Trays | Txn_Date | State_Code |
10007344 | NBG | 18/09/2013 12:33 | CMP |
10007344 | NBG | 18/09/2013 12:33 | RDY |
10007344 | NSS | 18/09/2013 16:23 | RDY |
10007344 | NSS | 19/09/2013 09:05 | RUN |
10007344 | NSS | 19/09/2013 09:07 | CMP |
10007344 | CJA | 19/09/2013 09:07 | RDY |
10007344 | CJA | 19/09/2013 09:11 | CMP |
10007344 | NCO | 19/09/2013 09:11 | RDY |
10007344 | NCO | 19/09/2013 09:20 | RUN |
10007344 | NCO | 19/09/2013 09:20 | CMP |
10007344 | NFU | 25/09/2013 08:28 | RDY |
10007344 | NFU | 25/09/2013 08:28 | RUN |
10007344 | NFU | 25/09/2013 08:28 | CMP |
10007344 | NCH | 25/09/2013 08:28 | RDY |
10007344 | NCH | 25/09/2013 11:56 | RUN |
10007344 | NCH | 25/09/2013 12:02 | CMP |
10007344 | NBO | 25/09/2013 12:02 | RDY |
10007344 | NBO | 25/09/2013 12:03 | RUN |
10007344 | NBO | 25/09/2013 12:07 | CMP |
10007344 | NCA | 25/09/2013 12:07 | CMP |
10007344 | NCA | 25/09/2013 12:07 | RDY |
More than Once example: Application moved into NSA twice, CJA three times etc.
Application_id | Tray | Txn_Date | State_Code |
10007616 | NBG | 12/09/2013 10:42:29 | CMP |
10007616 | NBG | 12/09/2013 10:42:29 | RDY |
10007616 | NSA | 12/09/2013 10:42:29 | RDY |
10007616 | NSA | 12/09/2013 11:25:55 | RUN |
10007616 | NSA | 12/09/2013 11:26:33 | CMP |
10007616 | CJA | 12/09/2013 11:26:33 | RDY |
10007616 | CJA | 12/09/2013 11:27:24 | CMP |
10007616 | NCO | 12/09/2013 11:27:24 | RDY |
10007616 | NCO | 12/09/2013 12:56:32 | RUN |
10007616 | NCO | 12/09/2013 13:00:24 | CMP |
10007616 | NSA | 12/09/2013 13:00:24 | RDY |
10007616 | NSA | 13/09/2013 16:20:38 | RUN |
10007616 | NSA | 13/09/2013 16:22:08 | CMP |
10007616 | CJA | 13/09/2013 16:22:08 | RDY |
10007616 | CJA | 13/09/2013 16:25:47 | CMP |
10007616 | NCO | 13/09/2013 16:25:47 | RDY |
10007616 | NCO | 13/09/2013 16:50:57 | RUN |
10007616 | NCO | 13/09/2013 16:51:47 | RDY |
10007616 | NCO | 16/09/2013 10:42:22 | RUN |
10007616 | NCO | 16/09/2013 10:43:00 | CMP |
10007616 | NFU | 16/09/2013 10:43:00 | SUS |
10007616 | NFU | 24/09/2013 08:31:02 | RDY |
10007616 | NFU | 24/09/2013 08:31:02 | RUN |
10007616 | NFU | 24/09/2013 08:31:05 | CMP |
10007616 | NCH | 24/09/2013 08:31:05 | RDY |
10007616 | NCH | 24/09/2013 12:13:58 | RUN |
10007616 | NCH | 24/09/2013 12:15:25 | CMP |
10007616 | NBO | 24/09/2013 12:15:25 | RDY |
10007616 | NBO | 24/09/2013 12:15:26 | RUN |
10007616 | NBO | 24/09/2013 12:16:01 | RDY |
10007616 | NBO | 24/09/2013 12:16:04 | RUN |
10007616 | NBO | 24/09/2013 12:16:05 | EXP |
10007616 | NCH | 24/09/2013 12:16:05 | RDY |
10007616 | NCH | 24/09/2013 13:25:26 | RUN |
10007616 | NCH | 24/09/2013 13:26:20 | CMP |
10007616 | NRD | 24/09/2013 13:26:20 | RDY |
10007616 | NRD | 24/09/2013 15:30:05 | RUN |
10007616 | NRD | 24/09/2013 15:30:07 | EXP |
10007616 | NCH | 24/09/2013 15:30:07 | RDY |
10007616 | NCH | 24/09/2013 15:30:08 | RUN |
10007616 | NCH | 24/09/2013 15:31:42 | CMP |
10007616 | NBO | 24/09/2013 15:31:42 | RDY |
10007616 | NBO | 24/09/2013 15:31:43 | RUN |
10007616 | NBO | 24/09/2013 15:37:25 | RDY |
10007616 | NBO | 24/09/2013 15:37:27 | RUN |
10007616 | NBO | 24/09/2013 15:37:32 | EXP |
10007616 | NSA | 24/09/2013 15:37:32 | RDY |
10007616 | NSA | 24/09/2013 15:39:51 | RUN |
10007616 | NSA | 24/09/2013 15:41:37 | CMP |
10007616 | CJA | 24/09/2013 15:41:37 | RDY |
10007616 | CJA | 24/09/2013 15:43:42 | CMP |
10007616 | NCO | 24/09/2013 15:43:42 | RDY |
10007616 | NCO | 24/09/2013 15:52:46 | RUN |
10007616 | NCO | 24/09/2013 15:53:44 | CMP |
10007616 | NFU | 24/09/2013 15:53:44 | SUS |
10007616 | NFU | 24/09/2013 15:53:47 | RDY |
10007616 | NFU | 24/09/2013 15:53:47 | RUN |
10007616 | NFU | 24/09/2013 15:54:06 | CMP |
10007616 | NCH | 24/09/2013 15:54:06 | RDY |
10007616 | NCH | 24/09/2013 15:54:08 | RUN |
10007616 | NCH | 24/09/2013 15:54:12 | CMP |
10007616 | NBO | 24/09/2013 15:54:12 | RDY |
10007616 | NBO | 24/09/2013 15:54:14 | RUN |
10007616 | NBO | 24/09/2013 15:55:56 | CMP |
10007616 | NCA | 24/09/2013 15:55:56 | CMP |
10007616 | NCA | 24/09/2013 15:55:56 | RDY |