Section Access Reduce Data - How to use conditional filter?

Wed, 29 May 2013 13:45:14 GMT

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

topic Section Access Reduce Data - How to use conditional filter? in QlikView

Section Access Reduce Data - How to use conditional filter?