Section Access for Data reduction

[richard24best]

Hi Everyone,

I have requirement to control access for users based on Product type and region.

Below is the script I am using

LOAD
    System
    EnteredDate,
    Date(monthstart(TradeEnteredDate),'MMM YYYY') as TradeEntered_MnthYr,
    PO,
    ProductType,
    CounterpartyType,
    Tradecount,

From XYZ.xls

For ex - If an user is from United Kingdom, should see only data related to Producttype = FX (related to UK)

Appreciate your assistance on implementing the section access as per above requirement.

Thanks in advance,

Richard

[dplr-rn]

You need a table which has relationship between region and product.

e.g.  with columns Region, ProductType

then you create section access on based on region

check this link for a primaer on section access

https://community.qlik.com/t5/Qlik-Sense-Documents/Making-Sense-of-Section-Access-in-Qlik-Sense/ta-p...

[richard24best]

Hi Dilip,

Thanks for your response.

Well now I have requirement where section access runs first on AD groups and use an excel with users list for data reduction. Any idea how can we do that please?

Thanks in advance,

Richard