Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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.

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

0 Replies