Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 nikhilgarg
		
			nikhilgarg
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hey,
Can anyone explain me the use of below under Document Properties?
Initial Selection Based on Section Access
Thanks
 MK_QSL
		
			MK_QSL
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		 Chanty4u
		
			Chanty4u
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		 
					
				
		
 Mark_Little
		
			Mark_Little
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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
		
			gsbeaton
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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
		
			avinashelite
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Nikhil,
Initial Selection Based on Section Access..will reduce the current selection according to the region which you have access ...
 gsbeaton
		
			gsbeaton
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Avinash,
That statement is somewhat misleading. It will not reduce, it merely selects, based on the user's logged on credentials.
 HirisH_V7
		
			HirisH_V7
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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
 
					
				
		
 oknotsen
		
			oknotsen
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		... 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.
 gsbeaton
		
			gsbeaton
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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
