Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Partner
Partner

Section access- 2 cases

I have a QVW, which has 2 mutually exclusive data sets. One is USER information and another is DOCUMENT information. The USER section access needs to controlled by USER_LOB (line of bsuiness) and DOCUMENT section access is controlled by DOC_LOB.

Here is an example:

USER TABLE:

USERUSER_LOB

USER1

SALES
USER2CAPITAL MARKETS
USER3CREDIT RISK
USER4SALES
USER5CREDIT RISK

DOCUMENT Table:

DOCUMENTDOC_LOBDOC USERS
DOC1

SALES

USER1
DOC2SALESUSER2
DOC3CREDIT RISKUSER3
DOC4CREDIT RISKUSER4
DOC5CAPITAL MARKETSUSER5

When USER1 Logs in, he should be able to see the data only for SALES from USER table (USER1 and USER4) and the 2 documents from DOCUMENT table (DOC1 and DOC2).

My problem is I do not how to use the section access based on 2 conditions.

Thanks in advance.

1 Solution

Accepted Solutions
alexpanjhc
Valued Contributor

Re: Section access- 2 cases

I believe the attached document can help you with this situation.

View solution in original post

8 Replies
alexpanjhc
Valued Contributor

Re: Section access- 2 cases

I believe the attached document can help you with this situation.

View solution in original post

Highlighted

Re: Section access- 2 cases

alexpanjhc

Hello.

Can you explain why if a use the code in that pdf and using the * for the admin, when it opens the document it's supposed to see all data but instead of it it only sees the ADMINGROUP (attached) data but can see anything else, i been having this problem with many documents and if i look at the table view and right clic on the aplication table and PREVIEW the data that is not shown has the value "Total" i don't understand this behaviour can you help me?

alexpanjhc
Valued Contributor

Re: Section access- 2 cases

u wanna sent the qvw?

Re: Section access- 2 cases

alexpanjhc Of course the qvw is attached and you will see i'm using the same script in the document in comment above "8QV9____Multi_Column_Data_Reduction.pdf

User: Admin

Pass: Admin

alexpanjhc
Valued Contributor

Re: Section access- 2 cases

at least in the document property->opening-> strict exclusion should be checked and prohbit binary load should be checked.

Re: Section access- 2 cases

Hi alexpanjhc

Even if i checked both options the behaviour is the same...

Partner
Partner

Re: Section access- 2 cases

The reduction tables need to be associated with the table that has the data.

See my example.

Best Regards.


Re: Section access- 2 cases

Fernando Tonial

I tested it and works! So we always has to create that last table to make the association and so the use of "star is *" works.

I'll try with other documents thank you in advance!