topic Re: Section access in QlikView

Section access

Gowtham174 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

From the below script User DF should have access only for DOMESTIC_FOREIGN but it will show for all other flight type.

Can you please help me to understand section access in details with the example.

Section Access; LOAD * INLINE [ ACCESS, USERID, PASSWORD, FLIGHTTYPE ADMIN, ADMIN, ADMIN123, * USER, DF, DF123, DOMESTIC_FOREIGN USER, DU, DU123, DOMESTIC_US USER, IF, IF123, INTERNATIONAL_FOREIGN ]; Section Application; LOAD * INLINE [ Flight Type, FLIGHTTYPE "Domestic, Foreign Carriers", DOMESTIC_FOREIGN "Domestic, US Carriers Only", DOMESTIC_US "International, Foreign Carriers", INTERNATIONAL_FOREIGN "International, US Carriers Only", INTERNATIONAL_US ];

Thanks,

Gowtham

Re: Section access

PrashantSangle — Tue, 19 Jun 2018 12:43:42 GMT

check document property > Opening > Initial Data Reduction Based on Section Access > Strict Exclusion must tick

Regards,

Re: Section access

jonathandienst — Tue, 19 Jun 2018 13:00:27 GMT

Remove the quotes from the inline table load. With the quotes like that, FLIGHTTYPE is not being populated so the SA is not working.

LOAD * INLINE [ Flight Type, FLIGHTTYPE "Domestic, Foreign Carriers", DOMESTIC_FOREIGN "Domestic, US Carriers Only", DOMESTIC_US "International, Foreign Carriers", INTERNATIONAL_FOREIGN "International, US Carriers Only", INTERNATIONAL_US ];