Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thank you, that works fine!!