topic Re: Section Access Does Not Select the Reduction Value in QlikView

Section Access Does Not Select the Reduction Value

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

I have the following code for the Section Access in Edit Script. I am not getting any of the values for the PB_Charge_CostCenterNamethe such as Cardiology to be selected upon logging in as Mickey or anyone in the code (Minnie, etc). None of the

[fPB_Charge]:

load

CostCenterName AS PB_Charge_CostCenterName

;

sql select

CostCenterName

from DW.cfn_Lookup_PB_Charges_Staging()

;

SECTION Access;

Authorization:

Load * Inline

[Access, Userid, Password, fPB_Charge.PB_Charge_CostCenterName

ADMIN, QTRAN, PASS1,

USER, MICKEY, PASS1, CARDIOLOGY

USER, MINNIE, PASS1, ENT

USER PLUTO, PASS1, GASTROENTEROLOGY

USER PLUTO, PASS1, ALLERGY CLINIC

];

Re: Section Access Does Not Select the Reduction Value

Anonymous — Wed, 24 May 2017 23:37:04 GMT

The fPB_Charge.PB_Charge_CostCenterName does not contain any selections when I log in using the above accounts such as Mickey. I have also tried just with PB_Charge_CostCenterName and that did not work.

Re: Section Access Does Not Select the Reduction Value

Anonymous — Wed, 24 May 2017 23:56:13 GMT

I added a comma after user and pluto (user, pluto) but I still have the problem of not getting anything selected for the PB_Charge_CostCenterName listbox

USER PLUTO, PASS1, GASTROENTEROLOGY

USER PLUTO, PASS1, ALLERGY CLINIC

Re: Section Access Does Not Select the Reduction Value

Anonymous — Thu, 25 May 2017 00:28:05 GMT

I capitalized CostCenterName using upper(CostCenterName) and it now works.