topic Section Access in QlikView

Section Access

Mon, 24 Feb 2014 22:08:13 GMT

Section Access;

Load [Access]

,[NTName]

,[UserName]

,[Password];

SQL SELECT *

FROM[Access];@

STAR is *;

LOAD UPPER([NTName]) as NTName

,[CostCenter]as COSTCENTER;

SQL SELECT *

FROM [CostCenter];

I must filter data based on costcenter

Will the above code work?

Initial Data reduction is turned on.

Strict exclusion turned on

Security - reduction - turned on.

Re: Section Access

chiru_thota — Mon, 24 Feb 2014 22:17:23 GMT

It should work.

Only error I can see is you should end the code with

SECTION APPLICATION;

Thanks,

Chiru

*******************************************************************

Section Access;

Load [Access]

,[NTName]

,[UserName]

,[Password];

SQL SELECT *

FROM[Access];@

STAR is *;

SECTION APPLICATION;

LOAD UPPER([NTName]) as NTName

,[CostCenter]as COSTCENTER;

SQL SELECT *

FROM [CostCenter];

******************************************************************

Re: Section Access

Mon, 24 Feb 2014 22:18:30 GMT

Thanks will try now..

Re: Section Access

hic — Tue, 25 Feb 2014 13:34:29 GMT

It is USERID, not UserName. And you need to use upper case. I.e.

Section Access;

Load Upper(Access) as ACCESS

,Upper(NTName) as NTNAME

,Upper(UserName) as USERID

,Upper(Password) as PASSWORD;

SQL SELECT * FROM [Access];

STAR is *;

LOAD UPPER([NTName]) as NTNAME

,UPPER(CostCenter) as COSTCENTER;

SQL SELECT * FROM [CostCenter];

Further, the "Star Is *" doesn't always solve the problem. It will only be matched against other values in this table - not the values of other tables.

HIC