Object security - two conditional layouts

Fri, 18 Apr 2014 19:14:24 GMT

I currently have the following section access logic applied to my QVW file and I am trying to apply the 2 different accesses (SIACCESS, EEMSACCESS) to two different objects.

So on one object I have the Layout > Conditional if(SIACCESS=1,1,0) and the other if(EEMSACCESS=1,1,0). The issue is the security being used for both is from the SIACCESS or SIDATA...is there a way to have separate accesses applied. i have also attached the .xls file referenced in the logic.

LOAD * INLINE [

    SIACCESS, EEMSACCESS

    1,1

    0,0

];

Section Access;

[Security Table]:

LOAD ACCESS,

     NTNAME,

     SIDATA,

     EEMSDATA

FROM

(ooxml, embedded labels, table is Sheet1);

Section Application;

LOAD * Inline [

SIDATA, SIACCESS, EEMSACCESS

Y,1,1

N,0,0

];

Re: Object security - two conditional layouts

juc — Wed, 23 Apr 2014 21:02:07 GMT

Hi Steve,

I think the problem here is that anytime you have a value of 1 for EEMS, you also have a value of 1 for SI:

Section Application;
LOAD * Inline [
SIDATA, SIACCESS, EEMSACCESS
Y,1,1
N,0,0
];

I think it would be better to control all access based off of one combined variable to be used in all show-hide conditions, rather than two.

SIDATA	EEMSDATA	CombinedVariable
Y	Y	3
Y	N	1
N	N	0
N	Y	2

In your show hide condition, you could have something like the following:

SI Charts:

=if(CombinedVariable=3,1,

If(CombinedVariable=1,1,0)

)

EEMS Charts:

=if(CombinedVariable=3,1,

If(CombinedVariable=2,1,0)

)

Hope this helps!

Thanks.

-Jesse

topic Re: Object security - two conditional layouts in QlikView

Object security - two conditional layouts

Re: Object security - two conditional layouts