Setting a temporary login access

[thanhphongle]

Hello Community,

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

Example:

File: Report.qv

Login: User1

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

[antoniotiman · Accepted solution]

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

[thanhphongle]

Thank you, that works fine!!