Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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
It does work if you observe the rules for section access and working data reduction:
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)
Thank you for taking time to educate me.
Thanks,
Prathip