topic Re: Calendar values dissapear when adding section access in QlikView

Calendar values dissapear when adding section access

digichap28 — Sat, 16 Nov 2024 19:04:19 GMT

Hi folks,

Before starting I want to mention I tried to find the solution on other topics and the one related was the following https://community.qlik.com/t5/QlikView-App-Development/Calendar-Disabled-When-View-On-QV-Server/td-p/268103 . unfortunately, it didnt help me with my issue.

So, this is the thing... (to make it simple) I developed an app which has 2 calendar tables linked to my fact table, and another one used to reduce the data with section access. The problem with it is that whenever I activate the section access on the document properties "Initial Data Reduction Based On Section Access" plus "Strict Exclusion", and reload the document on the server, one of my calendars disables some or all the values depending on the data loaded on my fact.

For instance: When the user "Admin" opens the app on a browser based on the data and section access setup which is below, the calendar object using the field "Date A" doesnt show the value 20/02/2020 even though it is actually available on the data model (as shown on the list box).

**FactTable**

%Id	%DateA	%DateB
1	43881	43881
5	43881	43881
1	43880	43880

**Calendar A**

%DateA	Date A
43880	19/02/2020
43881	20/02/2020

**Calendar B**

%DateB	Date B
43880	19/02/2020
43881	20/02/2020

**Regions**

%Id	Region	%REDUCTION
1	A	A
5	E	E

**Section Access Table**

ACCESS	NTNAME	%REDUCTION
ADMIN	QLIKVIEW\Admin	E

I have spent hours trying to figure out what Im doing wrong but gave up thinking it is actually a Qlikview bug.

I'm also attaching a QVW where I recreated whats happening on my original app. It should be deployed on a QV server and the section access should be activated with your user on the list instead of mine. Im adding also a QVD.

Note: The Hidden script password is "123".

By the way, the QV server I have is the 12.10.20300.0

I hope I was able to make this understandable and someone could guide me because Im lost now :S

Thanks in advance!!

Re: Calendar values dissapear when adding section access

digichap28 — Thu, 27 Feb 2020 15:25:39 GMT

I kept trying different things but havent found what is going on. No one knows what might be the problem or what my mistake could be ?

Re: Calendar values dissapear when adding section access

Brett_Bleess — Wed, 25 Mar 2020 20:07:07 GMT

Going to dump a few Design Blog posts for you to review, hopefully they may be able to get you on the right track with things.

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766

Note the other related post links at the bottom of that post... in particular the reduction posts...

https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

If these are not what you need, here is the base URL for the area you can use to search within that area to see if you can find other posts that may be more helpful.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett