Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

prathipsrinivas
Contributor

Data reduction Using Section Access

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

4 Replies
Highlighted

Re: Data reduction Using Section Access

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.

Highlighted
prathipsrinivas
Contributor

Re: Data reduction Using Section Access

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

Highlighted

Re: Data reduction Using Section Access

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)

Highlighted
prathipsrinivas
Contributor

Re: Data reduction Using Section Access

Thank you for taking time to educate me.

Thanks,

Prathip