Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
krishnabics
New Contributor

Can we have Circular Reference between Section Access and Section Application table(s)?

Hi Friends,

I would need some help to understand what happens while having Circular Reference between Section Access table and Section Application Table. I am also doing data reduction and using DMS Authorization(which may not matter here). But to my surprise, this is behaving differently for same user configuration, each time.

To be precise, I have exactly similar requirement as scripted below. But for some reason, my Product list is very huge, so I can't build compound key of Customer and Product in my data model.

I know QV tries to break the circular reference by making some tables loosely coupled. But at times data reduction is not working completely. So I just want to understand what is happening exactly on this case.

Section Access;

Security:   //IS_EXTERNAL_USER field tells if the user is external(outside domain), for them only few products are shown

LOAD * Inline [

NTNAME,CUSTOMERID,IS_EXTERNAL_USER

ABCD,C1,0

BCDE,C2,0

CDEF,C1,1

DEFG,C3,1

];

SECTION Application;

Fact:

LOAD * Inline [

Date,Customer,Product,SoldAmount

01/01/2010,Cust1,Prod1,120

01/02/2010,Cust3,Prod2,415

01/02/2010,Cust2,Prod3,150

01/03/2010,Cust1,Prod4,155

];

Exclusive_Products_External: //this means, only products which are listed here will be shown to External users

LOAD * Inline [

IS_EXTERNAL_USER,Product

1,Prod1

1,Prod2

];

Customer:

LOAD * Inline [

CUSTOMERID,Customer

C1,Cust1

C2,Cust2

C3,Cust3

];

Any explanation is appreciated!

Thanks!

Krishna.