topic Re: Initial Selection Based on Section Access ? in QlikView

Initial Selection Based on Section Access ?

nikhilgarg — Mon, 07 Sep 2015 12:58:33 GMT

Hey,

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

Initial Selection Based on Section Access

Thanks

Re: Initial Selection Based on Section Access ?

MK_QSL — Mon, 07 Sep 2015 13:25:43 GMT

Read this...

https://qliktech.hosted.jivesoftware.com/docs/DOC-8562

Re: Initial Selection Based on Section Access ?

Chanty4u — Tue, 09 Feb 2016 10:37:29 GMT

chk dis completely.

step by step.

Introduction to Section Access

Re: Can you explain the Section access? step by step

Re: Initial Selection Based on Section Access ?

Mark_Little — Tue, 09 Feb 2016 11:02:32 GMT

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

Re: Initial Selection Based on Section Access ?

gsbeaton — Tue, 09 Feb 2016 11:08:25 GMT

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.

Re: Initial Selection Based on Section Access ?

avinashelite — Tue, 09 Feb 2016 12:27:00 GMT

Hi Nikhil,

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

Re: Initial Selection Based on Section Access ?

gsbeaton — Tue, 09 Feb 2016 12:34:46 GMT

Hi Avinash,

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

Re: Initial Selection Based on Section Access ?

HirisH_V7 — Tue, 09 Feb 2016 13:13:36 GMT

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

Re: Initial Selection Based on Section Access ?

oknotsen — Tue, 09 Feb 2016 13:39:54 GMT

... 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.

Re: Initial Selection Based on Section Access ?

gsbeaton — Tue, 09 Feb 2016 14:11:45 GMT

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.

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

Try it for yourself .

Yours respectfully

George

Re: Initial Selection Based on Section Access ?

avinashelite — Wed, 10 Feb 2016 05:23:30 GMT

Hi George,

my statement of Reduce in means your dashboard will show the data related to your access not removing the data