topic Re: Data reduction Using Section Access in QlikView

Data reduction Using Section Access

prathipsrinivas — Fri, 12 Oct 2018 10:39:56 GMT

Hey Qlikers,

I am just wondering if we can do row level data reduction using Qlikview but without Basic Authentication fields like UserID and Password. I mean just by mentioning the reduction field and reduction values in Section Access.

Something like this;-

Section Access;

Load * Inline [

Field1

value1

value2

];

Section application;

load

Field1, field2

from table1;

Would it work? Is there a way we could achieve this.

Regards,

Prathip

Re: Data reduction Using Section Access

Peter_Cammaert — Fri, 12 Oct 2018 10:51:11 GMT

Yes, by simply adding WHERE clauses to the corresponding LOAD statements in your regular script.

Section Access is used to attach a verified User ID to

a set of data rows that should be visible (when using Data Reduction)
permssions to open this document and modify it (in QV Desktop only)
both of these

and let those properties be decided upon at document open time.

No user ID means no distinction, just a fixed reduction for everybody that can be preloaded at script execution time.

Re: Data reduction Using Section Access

prathipsrinivas — Fri, 12 Oct 2018 11:26:55 GMT

Hi Peter,

Yes, I totally agree we can filter it using Where clause while loading.

My Question is, Is same thing happens when we use the Section Access like I mentioned above for all users ?

or in other words,

The above approach and where clause expected to work same, right?

Thanks,

Prathip

Re: Data reduction Using Section Access

Peter_Cammaert — Fri, 12 Oct 2018 11:40:42 GMT

It does work if you observe the rules for section access and working data reduction:

all text field values that link across sections should be specified in upper case
all field names that link across sections should be specified in upper case.

Because Section Access converts everything to upper case by default (even USERID and PASSWORD values that your specifiy in the SA table or enter in the Login fields)

Re: Data reduction Using Section Access

prathipsrinivas — Fri, 12 Oct 2018 12:19:09 GMT

Thank you for taking time to educate me.

Thanks,

Prathip