Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

sometimes asks user/password,sometimes not -- a veces pide user/password, otras no

HI

I use de section access in the documents to control what information each user sees.

[CODE]
Section Access;
ACCESS_TABLE:
LOAD [ACCESS],
SERIAL,
NTNAME,
[PASSWORD],
GRUP
FROM excel.xls
·
·

Section Aplication;

REDUCTIONS:
LOAD * INLINE [
GRUP, COMPANY
GRUP1, 1
GRUP2, 2
GRUP3, 3
GRUP4, 4
];

[/CODE]

The value of [PASSWORD] is "*" (asterisk) so that when you open the document in IE does not request username/password. I do not want to ask username/password.

Apparently it works well, but sometimes it asks user/password... It is not always in the same documents or the same users. A user who opens the document well today, tomorrow, without making script or access level changes, asks user/password.

Qlikview 9 and documents are opened in IE.

THANKS!

-------------------------------------------------------------------------------------------------------------------------

Buenas,

Utilizo la seccion de acceso del script para poder controlar que informacion ve que usuarios. En el script cargo un excel donde tengo la lista de usuarios con el NTNAME, GRUPO... y password donde indico "*" para que cuando el usuario accede NO aparezca la ventana solicitando la contraseña. También tengo marcada la opcion de "Reduccion inicial de datos basada en..." y "Exclusion Estricta" (aprovecho para preguntar por esta 2º opcion. Que diferencia hay entre estricta y "no estricta"?)

[CODE]
Section Access;
ACCESS_TABLE:
LOAD [ACCESS],
SERIAL,
NTNAME,
[PASSWORD],
GRUP
FROM excel.xls
·
·

Section Aplication;

REDUCTIONS:
LOAD * INLINE [
GRUP, COMPANY
GRUP1, 1
GRUP2, 2
GRUP3, 3
GRUP4, 4
];

[/CODE]

Parece que todo funciona correctamente pero ocurre que a veces un usuario que ha entrado perfectamente hoy, mañana le pide usuario y password al intentar abrir el documento. No ocurre con todos los usuarios, ni con un usuario en particular ni con un documento concreto. Ejemplo: Una usuaria que ayer tenía problemas para acceder a un documento "X" hoy puede entrar en ese, pero en el documento "Y" no, cuando esos documentos no han sido modificados...

GRACIAS

-------------------------------------------------------------------------------------------------------------------------

1 Solution

Accepted Solutions
prieper
Master II
Master II

Encounter this also from time to time, typically after having changed layout or script of the application without refreshing same.

Peter

View solution in original post

6 Replies
prieper
Master II
Master II

Encounter this also from time to time, typically after having changed layout or script of the application without refreshing same.

Peter

Not applicable
Author

Hi IMQLIK,

maybe using star is *; ?

Mario

--------------------------------------------------------------------------------

Hola IMQQLIK,

como pones "*" en el usuario, ¿le pones la sentencia star is *;?

Mario


Not applicable
Author

Hi Peter,

and how to solve the problem?

Every time you make a design change, your reload the document?

Sometimes, a user can enter well into a document and other user not (to de same document...)

THANKS

Not applicable
Author

Hola Mario,

Los datos de la seccion de acceso los tengo en un archivo excel porque son comunes en todos los documentos y así es mas facil hacer cambios. El asterisco está puesto como tal "*", sin ";" y normalmente funciona bien. Como decía, a veces pide y a veces no...

Probaré a ponerlo "*;" como dices a ver que ocurre...

GRACIAS!

prieper
Master II
Master II

If your problem is with different users with the same rights - one can enter, one not, would review the access-script and/or check the environment, network-connections etc of the users.

Following the previous discussions think that it is wise, not to give all changes straight into production or to program on production-versions. For some (heavy) documents we have - comparable with a frontend- and backend-solution - a script-version and a layout-version. The latter refers via binary load to the script-version. Whenever we make changes only in the layout, a fast binary refresh to be executed, which typically takes only 1-2 minutes.

Peter

Not applicable
Author

We check that when you save the document without reloading, the user can not enter (ask user / password). Then after reload the document again the user can access

THANKS