Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 
prathipsrinivas
Creator
Creator

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

Prathip
4 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

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.

prathipsrinivas
Creator
Creator
Author

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

Prathip
Peter_Cammaert
Partner - Champion III
Partner - Champion III

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)

prathipsrinivas
Creator
Creator
Author

Thank you for taking time to educate me.

Thanks,

Prathip

Prathip