topic Re: Why a left join is needed with the section application and data in QlikView

Why a left join is needed with the section application and data

rarora12 — Thu, 10 Aug 2017 21:03:56 GMT

Hi,

I am trying to use security to limit the data the user can see per region + limit the tab the user can see

It doesn't work unless I do a left join to the section application

I can get the tab visibility to work but not both without the left join - as displayed below

Thanks in assisting me what I am missing

Rick

===========================

Section Access;

security:

LOAD * INLINE [

ACCESS, NTNAME ,ROLE

USER,BNDNA\ARORAR,A

];

Section Application;

SheetAccess:

LOAD * Inline [

ROLE,REGION,SH01,SH02,SH03,

A,SOUTH,0,0,1

A,WEST,0,0,1];

left join (SheetAccess)

regiondata:

LOAD * INLINE [

REGION, dpp_id, name, location

SOUTH, BAd111, badguy, MD

NORTH, BAd333, badguy22, MDVA

WEST, BAd222, badguy22, MDVA

];

Re: Why a left join is needed with the section application and data

Anonymous — Fri, 11 Aug 2017 07:06:53 GMT

Section Access;

security:

LOAD * INLINE [

ACCESS, NTNAME ,ROLE

USER,BNDNA\ARORAR,A

];

Section Application;

SheetAccess:

LOAD * Inline [

ROLE,REGION,SH01,SH02,SH03,

A,SOUTH,0,0,1

A,WEST,0,0,1];

//left join (SheetAccess)

regiondata:

LOAD * INLINE [

REGION, dpp_id, name, location

SOUTH, BAd111, badguy, MD

NORTH, BAd333, badguy22, MDVA

WEST, BAd222, badguy22, MDVA

];

and put condition on each sheet

for sheet id 3

SH03=1

Its working its showing only SH03 and for region its showing only south and west without left join

Re: Why a left join is needed with the section application and data

rarora12 — Fri, 11 Aug 2017 14:27:41 GMT

I don't get the same results - maybe i have the setting setup incorrectly.

Can i ask what is the difference in setting tab to =SH03 vs SH03=1

It just doesnt work for me

Thanks