topic Re: How to use OMIT in section access? in QlikView

How to use OMIT in section access?

Anonymous — Sat, 31 Jan 2015 21:07:09 GMT

I have the below section access script. I want USER1 unable to see Cost. How can I achieve it by using OMIT.

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, OMIT

ADMIN, ADMIN, ADMIN123

USER, USER1, USER123, COST

];

Section Application;

LOAD * INLINE [

Cost, COST

];

excel sheet is also attached.

many Thanks

Re: How to use OMIT in section access?

fkeuroglian — Sat, 31 Jan 2015 21:48:49 GMT

Hi John

Maybe -

Check the selected option “Settings” -> “Document Properties” -> “Opening” ->Strict Exclusion is checked?

try this or put and upper function in the COST field

good luck

Fernando

Re: How to use OMIT in section access?

prieper — Sat, 31 Jan 2015 21:52:18 GMT

Did you set "Initial Datareduction ...."?

Peter

Re: How to use OMIT in section access?

Anonymous — Sat, 31 Jan 2015 22:05:45 GMT

HI all, I have checked both "Initial data Reduction" and "Strict exclusion" Still, Cost field is showing for user1. Fernando, what do you mean by put upper function in cost field? Excel sheet has "Cost" and I have "COST" under OMIT in section access. Then in section application, I have "mapped" "COST" to "Cost" i am hoping this is the correct way. If you see any thing can you please advise..?

Re: How to use OMIT in section access?

Colin-Albert — Sat, 31 Jan 2015 23:07:51 GMT

You need to rename the Cost field to COST, or load the field twice from excel as Cost & COST.

The field names must be uppercase for section access.

I do not believe your one line inline load does anything, it just creates an empty table.

Re: How to use OMIT in section access?

Anonymous — Sat, 31 Jan 2015 23:58:23 GMT

Thanks Colin, that worked.