topic Re: Section access not filtering correctly in QlikView

Section access not filtering correctly

Fri, 16 Aug 2013 15:20:11 GMT

Hi guys,

I seem to be having a problem filtering my data based on access.

The example I have is where lets say I login with an SID of AB1029.
This should filter and return roughly 6000 CLIENT_ID.. however I seem to be getting around 40,000.
I'm not sure where my problem is and I was wondering if my section access code's logic is correct.

section access;

star is *;

LOAD 'ADMIN' as [ACCESS],

'*' AS NTNAME,

SID as [USERID],

'*' as [PASSWORD],

'*' as SERIAL,

CLIENT_ID

FROM $(QVD_FOLDER)userINFO.qvd (qvd) where 1=1;

userINFO has two columns.
SID and CLIENT_ID

An associated SID has a set amount of client_IDS.

NOTE:

This is the other data I'm as well loading.

Section application;

Directory;

LOAD

CLIENT_ID,

CLIENT_NAME,

Date(MEETING_DATE,'MM/DD/YYYY') as CALENDAR_DATE,

MEETING_IDENTIFCATION

FROM

QVD\Info.qvd

(qvd)

Re: Section access not filtering correctly

swuehl — Fri, 16 Aug 2013 16:15:58 GMT

AFAIR, no data reduction for ADMIN access...

Try a USER access (after making a backup of your file...)

Re: Section access not filtering correctly

Fri, 16 Aug 2013 16:27:57 GMT

hmm, gives me same results. I think I had roughly 20k when it's not filtered (without section access). When I log on to any particular user, it seems to only be giving me 14k (With user or admin). This number is way too big however. Is my logic above correct (for filtering client_ids)

Re: Section access not filtering correctly

swuehl — Fri, 16 Aug 2013 19:59:55 GMT

How do the CLIENT_ID values look like?

I think they need to be all upper case.

Re: Section access not filtering correctly

Anonymous — Tue, 20 Aug 2013 01:32:55 GMT

In addition to Steven...

No matter how the values look like, use upper() in both section access and section application. I recommend to use upper for all section access fields.

Next - did you check "data reduction based on section access" in the document properties?

Regards,

Michael