topic Re: Section access- 2 cases in QlikView

Section access- 2 cases

parpatra — Fri, 03 May 2013 18:41:43 GMT

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:

USER	USER_LOB
USER1	SALES
USER2	CAPITAL MARKETS
USER3	CREDIT RISK
USER4	SALES
USER5	CREDIT RISK

DOCUMENT Table:

DOCUMENT	DOC_LOB	DOC USERS
DOC1	SALES	USER1
DOC2	SALES	USER2
DOC3	CREDIT RISK	USER3
DOC4	CREDIT RISK	USER4
DOC5	CAPITAL MARKETS	USER5

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.

Re: Section access- 2 cases

alexpanjhc — Fri, 03 May 2013 19:58:44 GMT

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

Re: Section access- 2 cases

Emmanuelle__Bustos — Thu, 13 Jun 2013 19:02:24 GMT

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?

Re: Section access- 2 cases

alexpanjhc — Fri, 14 Jun 2013 02:48:53 GMT

u wanna sent the qvw?

Re: Section access- 2 cases

Emmanuelle__Bustos — Fri, 14 Jun 2013 14:24:20 GMT

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

Re: Section access- 2 cases

alexpanjhc — Sat, 15 Jun 2013 03:29:06 GMT

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

Re: Section access- 2 cases

Emmanuelle__Bustos — Mon, 17 Jun 2013 18:22:22 GMT

Hi alexpanjhc

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

Re: Section access- 2 cases

fernando_tonial — Mon, 17 Jun 2013 18:47:15 GMT

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

See my example.

Best Regards.

Re: Section access- 2 cases

Emmanuelle__Bustos — Mon, 17 Jun 2013 19:01:50 GMT

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!