topic Section Access with Module & Submodule in listbox not working in server in QlikView

Section Access with Module & Submodule in listbox not working in server

Fri, 27 May 2011 10:58:24 GMT

Dear All,

Please go through below my problem and attached a sample document developed.

In my application we have Module

Module -> Dashboard, Operation, Market

Each module will have below Submodules

Dashboard -> Master , Mini1 , Mini2

Operation -> Opr1, Opr2, Opr3

Market -> Mkt1, Mkt2, Mkt3, Mkt4

Basis above we have 10 sheets created and conditional show hide given basis the module & Submodule selections

In the script the tables extracted seperately with below information

Module

Dashboard

Operation

Market

all the above extracted tables are related with "SheetID" and each table ends with Loosen table <tablename>

The above modules taken into seperate list boxes and selected one filed from each module and submodule and given as "alway one selected" from general tab of listbox properties.

I have created a excel sheet with Users and Sheets access to filter the sheets as per user login.

ADMIN: given access for all sheets

NORMAN: given access for Mini1, Opr1, Opr2, Opr3

PETER: given access for Master, Mkt2, Mkt3

the excel sheet is attached with this, Excel sheet is extracted into application & put into the section access with proper syntax.

Section access is enabled for the application, saved the document & reloaded successfully..

When the application opened with given userID's, Listboxes contains of Module & submodule name filters correctly....

but when same application is been put into the server and launched with the UserID's, Listboxes are not filtering, each list box shows full information.

It filteres correctly when opening in the Developer environment, why it is not doing the same in Server...

My requirement should go as it works in the Developer environment.

Please help me where I am doing wrong with this.

Presently working with QV9 SR6 (Developer & Server)

attached zipfile consists of

1. Application

2. Menu_NC1 -> User & Sheets access information

3. few (4) qvd files.

Section Access with Module & Submodule in listbox not working in server

mike_garcia — Fri, 27 May 2011 16:05:19 GMT

The section access portion of the script MUST be the first to be executed. You have it at the very end.

It is not actually working netither in my desktop client nor in the server.

Mike.

Section Access with Module & Submodule in listbox not working in server

stephencredmond — Fri, 27 May 2011 16:12:09 GMT

Hi,

There is no problem putting the Section Access anywhere in your script.

The problem is that QVS is not working with your loosely coupled tables. Is there a particular reason why you are setting them loose? The document works fine in QVS if you do not have them loose.

Regards,

Stephen

Section Access with Module & Submodule in listbox not working in server

Tue, 07 Jun 2011 08:35:56 GMT

Hi Stephen,

sorry for late response and thanks for your understanding.

When going to each module, under each module the submodule listbox has to be in always one selected mode.

because when end user navigates from module to module, the selected submodule listbox will let the user know on which sheet presently looking at.

I tried with removing Loosen table, it works fine in the developer as well as server.

But when applied the Lossen table concept, it was working fine in developer, why it will not work in the server.

Regards,

Chenna

Section Access with Module & Submodule in listbox not working in server

stephencredmond — Tue, 07 Jun 2011 08:46:53 GMT

Hi Chenna,

I might look at creating a text object to show the users the information about what they are looking at. Use the QVUser (or OSUser) functions to generate them.

Regards,

Stephen

Section Access with Module & Submodule in listbox not working in server

Tue, 07 Jun 2011 09:31:06 GMT

HI Stephen,

If I am not wrong, the qlikview applications should be running same way in Server and Developer.

But why the document behaves differently in Server & Developer.

KIndly help in this regard. Thank you

Regards,

Chenna