Session Access not working properly (QV11)

Thu, 16 Aug 2012 10:34:37 GMT

Hi Guys,

I encountered a weird situation wherein section access is not working properly. If I login using AA, the COUNTRY is filtered by INDIA, which supposed to see all the data. If I login using BB, COUNTRY is filtered correctly. Is this a bug or did I miss something?

Here's my code:

SECTION ACCESS;

SECURITY_TABLE:

LOAD * INLINE

[

ACCESS, USERID, PASSWORD, NTNAME, COUNTRY

ADMIN , AA, AA, *, *

USER , BB, BB, *, INDIA

]

;

SECTION APPLICATION;

LOAD * INLINE [

COUNTRY

AUSTRALIA

SINGAPORE

PHILIPPINES

INDIA

];

Thanks,

Ronald

Re: Session Access not working properly (QV11)

rajni_batra — Thu, 16 Aug 2012 11:51:06 GMT

when we use * as above u have written it will display only values of Country you defined in inline Table,

if you want to display all the countries then u have to write then in the table,

e.g.

ACCESS, USERID, PASSWORD, NTNAME, COUNTRY

ADMIN , AA, AA, *, INDIA

ADMIN , AA, AA, *, AUSTRALIA

ADMIN , AA, AA, *, U.S.A

USER , BB, BB, *, INDIA

OR(IN EXCEL)

ACCESS USERID PASSWORD NTNAME COUNTRY

ADMIN AA AA * *

USER BB BB * INDIA

AUSTRALIA

U.S.A

Hope to Help !!!

topic Re: Session Access not working properly (QV11) in QlikView

Session Access not working properly (QV11)

Re: Session Access not working properly (QV11)