topic Section Access issue with Qlikview in QlikView

Section Access issue with Qlikview

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have problem with regard to Data reduction using section access in Qlikview. I am fetching user id details along with associated state operation to reduce data as per assigned state op.

When I am using only STRICT EXECLUSION option, data is not reducing and users can have access to whole dashboard but when I am using INITIAL DATA REDUCTION BASED ON STRICT SECTION ACCESS along with STRICT EXCLUSION, then users are not able to access dashboard from access point, when they open dashboard they redirects back to login page.

Thanks

Uday Behera

Re: Section Access issue with Qlikview

Gysbert_Wassenaar — Wed, 09 Mar 2016 19:09:46 GMT

That seems to indicate that section access is working properly but your section access table doesn't allow your users to see any data. Perhaps you can post more information like the part of the script that relates to section access.

Re: Section Access issue with Qlikview

Peter_Cammaert — Wed, 09 Mar 2016 20:12:59 GMT

And BTW, you cannot use "Strict Exclusion" on its own, i.e. without enabling "Initial Data reduction based on section access". The "Strict Exclusion" checkbox may seem to be marked, but without "Initial Data Reduction" being enabled as well, it will be greyed out, meaning that this option will not be in effect.

Strict Exclusion can only be selected/changed if Initial Data Reduction is enabled. That's also the reason why Strict Exclusion is indented underneath the Initial Data Reduction option. The former depends on the latter being enabled.

Best,

Peter

Re: Section Access issue with Qlikview

Thu, 10 Mar 2016 11:32:37 GMT

Hi Gybert,

I've attached below piece of section code and it seems fine from my end.

Re: Section Access issue with Qlikview

Chanty4u — Thu, 10 Mar 2016 11:34:50 GMT

u can use UPPER() function in section access always

Re: Section Access issue with Qlikview

Chanty4u — Thu, 10 Mar 2016 11:36:00 GMT

FYI

Section Access