topic Re: Setting a temporary login access in QlikView

Setting a temporary login access

thanhphongle — Wed, 12 Jul 2017 08:44:42 GMT

Hello Community,

is there a way to give a temporary access to a user for a qlikview Application?

Example:

File: Report.qv

Password: User1pw

Access valid from: 01.07.2017 - 31.07.2017

On 01.08.2017 the password should not be valid anymore.

Currently I am using :

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD

ADMIN, ADMIN, admin

USER, User1, User1pw

];

SECTION APPLICATION;

I hope anyone can help me out here

Re: Setting a temporary login access

antoniotiman — Wed, 12 Jul 2017 09:10:10 GMT

HI Thanh,

try SA like this

SECTION Access;
LOAD
If(Len(Trim(DATEMIN))=0 or (DATEMIN <= Today() and DATEMAX >= TODAY()),ACCESS) as ACCESS,
If(Len(Trim(DATEMIN))=0 or (DATEMIN <= Today() and DATEMAX >= TODAY()),USERID) as USERID,
If(Len(Trim(DATEMIN))=0 or (DATEMIN <= Today() and DATEMAX >= TODAY()),PASSWORD) as PASSWORD Inline [
ACCESS,USERID,PASSWORD,DATEMIN,DATEMAX
ADMIN,ADMIN,ADMIN,,
USER,USER1,USER1,01/01/2017,01/07/2017
USER,USER2,USER2,01/01/2017,31/07/2017
];

SECTION Application;

Regards,

Antonio

Re: Setting a temporary login access

thanhphongle — Wed, 12 Jul 2017 09:50:55 GMT

Thank you, that works fine!!