Hello Experts...
Apprecaite your time!
I am using Qlikview 11
I will need to add Section Access to reduce data based on who logged in.
If a sales rep logged in I was able to reduce data to that rep transactions, but now I will need to add logic for a manager a manager can
see a group of reps transactions. I am not sure how to approach the conditional scenario.
Reduce data by rep I am reducing rep field.
Reduce data by manager I will need to reduce data by manager field.
How to switch the reduce data field to if a rep logged in rep field and if a manager logged in manager field.
I am maintaining the user data in excel with fields ACCESS, NTNAME, SALESIDENTIFIER_REDUCE.
Please do let me know if i can explain the scenario further.
I have pasted my security code.... and selected - Document Properties/Opening/Initial Data Reductio based on Section Access with Strict Exclusion selected.
star is *;
////---------------------------------------------------
////-S E C U R I T Y S T A R T
////---------------------------------------------------
Section Access;
LOAD ACCESS,
NTNAME,
SALESIDENTIFIER_REDUCE
FROM ..\QVW\Qlikview_Access_User.xlsx(ooxml, embedded labels, table is Sheet1);
////---------------------------------------------------
Section Application;
SecurityTable:
LOAD * INLINE [
SALESIDENTIFIER_REDUCE,
SALESIDENTIFIER
ALL, *
];
Concatenate
LOAD
(Upper(SALESIDENTIFIER))as SALESIDENTIFIER_REDUCE,
SALESIDENTIFIER
Resident UserInformation;
//---------------------------------------------------
//-S E C U R I T Y E N D
//---------------------------------------------------
Thank you,
Pad
