topic Re: Showing Nulls in Access point with section access in QlikView

Showing Nulls in Access point with section access

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

I used below script for the section access. When I/my colleague opens it through desktop we were able to see valid value, But through access point it was showing as nulls. And the dimension was created out of a cyclic dimension group and field used in this cyclic group was not the one used in section access. The %REGION field had the values of different regions like south, west etc.,

Section Access;

LOAD upper(ACCESS) as ACCESS,

upper(NTNAME) AS NTNAME,

upper(%REGION) as %REGION

FROM

[http:xxxx/QMS/AuthTable]

(html, utf8, embedded labels, table is [SA_Dashboard]);

Section Application;

Desktop view

Access point View

Cyclic Group and Field used for this dimension (Location Branch)

Re: Showing Nulls in Access point with section access

Anil_Babu_Samineni — Sat, 02 Jun 2018 04:18:29 GMT

For me it sounds - You didn't engage any section access for your group? Can you share which expression it makes problem?

Re: Showing Nulls in Access point with section access

Anonymous — Sat, 02 Jun 2018 16:15:49 GMT

@Anil,

Don't go by the $0, as it's the first of the month, it's showing like that. I am able to see the numbers when I select previous months, the only issue is the discrepancy between desktop and access point view. I am not sure what exactly is causing the issue, but it's for the Channel and two of the other cyclic dimensions. I have highlighted the expression for which it was showing nulls. Basically if the LocationBranch is null or blank it should show as adjustments. I have given admin access to qvservices and my colleague, and for me I only assigned south. But my colleague nor me can see that as adjustment when we open the dashboard through AccessPoint.

Re: Showing Nulls in Access point with section access

pradosh_thakur — Sat, 02 Jun 2018 20:16:06 GMT

Did you add the system user account as an admin in the section access script ?

Re: Showing Nulls in Access point with section access

Anonymous — Sat, 02 Jun 2018 21:50:04 GMT

@Pradosh

Yes I have given admin access for system user account.