Section Access Reduce Data - How to use conditional filter?
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.
staris *; ////--------------------------------------------------- ////-S E C U R I T Y S T A R T ////--------------------------------------------------- SectionAccess; LOADACCESS, NTNAME, SALESIDENTIFIER_REDUCE FROM ..\QVW\Qlikview_Access_User.xlsx(ooxml, embeddedlabels, tableis Sheet1); ////--------------------------------------------------- SectionApplication; SecurityTable: LOAD * INLINE[ SALESIDENTIFIER_REDUCE, SALESIDENTIFIER ALL, * ]; Concatenate LOAD (Upper(SALESIDENTIFIER))asSALESIDENTIFIER_REDUCE, SALESIDENTIFIER Resident UserInformation; //--------------------------------------------------- //-S E C U R I T Y E N D //---------------------------------------------------