Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
nikhilgarg
Specialist II
Specialist II

Initial Selection Based on Section Access ?

Hey,

Can anyone explain me the use of below under Document Properties?

Initial Selection Based on Section Access

Thanks

10 Replies
MK_QSL
MVP
MVP

Chanty4u
MVP
MVP

Mark_Little
Luminary
Luminary

Hi,

As far as i am aware you use this options to just make the selections on opening instead of reducing the data.

So the user still have access to all the data, just start with the relevant data selected.

Mark

gsbeaton
Creator II
Creator II

That's correct Mark.  So if your Section Access reduction key was, for example, Country, and your logged in user had access to Scotland and Sweden, rather than reducing all other combinations, QlikView makes an initial selection on these two countries.

avinashelite

Hi Nikhil,

Initial Selection Based on Section Access..will reduce the current selection according to the region which you have access ...

gsbeaton
Creator II
Creator II

Hi Avinash,

That statement is somewhat misleading.  It will not reduce, it merely selects, based on the user's logged on credentials.

HirisH_V7
Master
Master

Hi,

In this example, when QlikView asks for UserID you can use 1, 2, 3 or SuperUser.

In the real App you can define the team based on the user login (with NTNAME on section access).

Please, check the script and Document Properties- > Opening

PFA,

HTH,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
oknotsen
Master III
Master III

... and even your reply can be seen as misleading, because it actually does not select those values but it actually hides all values not related to the user.

If you are related to, for example, 2 values, those 2 values are available yet you can still select both or just 1 of those values.

May you live in interesting times!
gsbeaton
Creator II
Creator II

Hi Onno,

I don't want to get into a flame war here, but I beg to differ.  Consider the following code:

SECTION Access;

SA_TABLE:

LOAD * INLINE [

ACCESS,NTNAME,COUNTRY

ADMIN, UKWIN-GBN\george, SCOTLAND

ADMIN, UKWIN-GBN\george, SWEDEN

];

SECTION Application;

TheData:

LOAD * INLINE [

COUNTRY, Coolness Rating

SCOTLAND, 100

SWEDEN, 99

ENGLAND, 55

];

When you check the Initial Selection Based on Section Access checkbox, then Scotland and Sweden get selected, automatically, upon reopening.

SA-Initial-Selection.png

Of course all values are still available for selecting and deselecting, this is just the initial selection.

Try it for yourself .

Yours respectfully

George