Problem with section access

Thu, 25 Jun 2015 13:50:26 GMT

I used this code to create a QVD for the section access

original:

LOAD

USERID,

DIMENSION,

VALOR

FROM

[..\XLSX\SEGURIDAD.xls]

(biff, embedded labels, table is Nuevo$);

Temp1:

Generic load * resident original;

result:

load distinct USERID resident original;

drop table original;

FOR i = 0 to NoOfTables()

TableList:

LOAD TableName($(i)) as Tablename AUTOGENERATE 1

WHERE WildMatch(TableName($(i)), 'temp1.*');

NEXT i

FOR i = 1 to FieldValueCount('Tablename')

LET vTable = FieldValue('Tablename', $(i));

LEFT JOIN (result) LOAD * RESIDENT $(vTable);

DROP TABLE $(vTable);

NEXT i

drop table TableList;

LEFT JOIN

LOAD ACCESS,

USERID,

PASSWORD,

TABLERO

FROM

[..\XLSX\SEGURIDAD.xls]

(biff, embedded labels, table is Nuevo$);

NoConcatenate

Seguridad:

LOAD

USERID,

if( IsNull (NEGOCIO), '*', NEGOCIO) AS NEGOCIO,

if( IsNull (MERCADO), '*', MERCADO) AS MERCADO,

PASSWORD,

ACCESS,

TABLERO

resident result;

DROP TABLE result;

the result, for example, is

ACCESS	USERID	PASSWORD	MARKET	BUSINESS	TABLERO
ADMIN	ADMIN	A	*	*	T
USER	EDUARDO	A	*	1	T
USER	JEREMIAS	A	2	*	T

MARKET and BUSINESS are the fields that i wanna hide (or don't hide) to the users.

Now. The problem is that i don't know why, this isn't working.

For example, with the admin user, i can't see all the market and business. I only see Business = 1, and MARKET = 2

And with the other users i can only see MARKET = 2, and BUSINESS = 1.

Do you now why?

Thank you, Greetings.

topic Problem with section access in QlikView

Problem with section access