topic Re: Section Access - Reducing Data + Using "OMIT" in unison in QlikView

Section Access - Reducing Data + Using "OMIT" in unison

Tue, 18 Feb 2014 19:05:58 GMT

Hello,

I am creating section access and attempting to reduce data in some fields and omitting others entirely. Is this possible to do in a single table?

I am loading a section access table from excel rather than doing an inline load; my columns are:

ACCESS	NTNAME	REGION	OMIT
ADMIN	ANANT\USER1
USER	ANANT\USER2	EU	SALES_AMT

Where user 1 would have access to everything, and user two should just see data for the EU region and not see ANY data from the SALES_AMT field.

Currently, the region is being reduced correctly but sales_amt is not being omitted.

Thanks,

Stephan

Re: Section Access - Reducing Data + Using "OMIT" in unison

Gysbert_Wassenaar — Tue, 18 Feb 2014 19:14:47 GMT

Is the real field name SALES_AMT or sales_amt? Qlikview is case sensitive. Make sure to use the exact case sensitive name.

Re: Section Access - Reducing Data + Using "OMIT" in unison

Tue, 18 Feb 2014 19:18:18 GMT

I am matching the case, however I thought I read that section access interprets everything as capitals anyways. Could this be an issue if my field name has lower cases in it?

Re: Section Access - Reducing Data + Using "OMIT" in unison

Gysbert_Wassenaar — Tue, 18 Feb 2014 19:21:55 GMT

Could be. One way to find out is to simply try it. Load the field name twice, lower case and upper case.

Add the same user + field combination again in the access table with the capitalized field name. Then reload and check which fields gets omitted.

Re: Section Access - Reducing Data + Using "OMIT" in unison

Tue, 18 Feb 2014 19:24:31 GMT

I have tried using the field in section access as all caps and as it appears in the data. Neither way worked.

Would it possible that I have to actually rename the field in the data itself so that it is all caps?

Have you had any luck using fields with lowercase letters in section access?

Re: Section Access - Reducing Data + Using "OMIT" in unison

Gysbert_Wassenaar — Tue, 18 Feb 2014 19:37:10 GMT

Works for me either way. Inline load or from an excel file makes no difference and the field name does not have to be capitalized. All case combinations work as long as the field name in the OMIT column of the section access table matches the real field name. Can you post the offending document? Or an example that demonstrates the problem?

Re: Section Access - Reducing Data + Using "OMIT" in unison

Tue, 18 Feb 2014 22:33:19 GMT

Well I got it to work, but it seems to be having a HUGE impact on performance. Like it seems to lock up for a while when I navigate to the tabs which have omitted fields (I am omitting an entire table...).

So I have two questions:

Is it possible to omit an entire table at once rather than having to list every single field?

And if not, is it possible to omit an entire tab in the application to a user using section access?

Re: Section Access - Reducing Data + Using "OMIT" in unison

Gysbert_Wassenaar — Wed, 19 Feb 2014 11:18:22 GMT

It's not possible to omit an entire table afaik.

If by tab you mean sheet, then yes that can be done with section access. You'll also want to restrict the options to add/modify sheets and sheet objects. See this document: Section Access - Hide Sheet Level

Re: Section Access - Reducing Data + Using "OMIT" in unison

Wed, 19 Feb 2014 17:44:41 GMT

It says that access to that content is restricted... any way you could send me the text that is there? (or give me access if you have that ability)

Re: Re: Section Access - Reducing Data + Using "OMIT" in unison

Gysbert_Wassenaar — Wed, 19 Feb 2014 17:49:24 GMT

That's weird. The document is published in the resource library (All Places > Resource Library > Documents). As long as you're logged in on community.qlik.com you should be able to access it. I've attached it to this post. Perhaps that does work for you.