Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 New-Qlik
		
			New-Qlik
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
I have a table showing data for five fiscal year.
I want to put condition that by default it should show current fiscal year but user can select any other year from filter panel and than table with reflect that selected year data.
Thanks
Avneet
 dreweezy
		
			dreweezy
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I had this issue as well and the only way to do so is using book mark or this new feature I found recently.
If you go to your left hand side, under "Fields", search for the field you want to have a default selection. Now when you click over that field, select the first icon (field settings) and select "Always select on value". The only issue is users will not be able to select multiple values but this will give you a default value pre-defined. I have tried using variables and etc but not much luck besides using the bookmark methodology and this one I have mentioned. I'd assume Qlik will have a capability like this in their next release as it is usually a basic capability in most business intelligence suites.
 skamath1
		
			skamath1
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		You can create a bookmark with the selection and set as default bookmark that will apply when the user opens the sheet.
Check the help for more details
 New-Qlik
		
			New-Qlik
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		 dreweezy
		
			dreweezy
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I had this issue as well and the only way to do so is using book mark or this new feature I found recently.
If you go to your left hand side, under "Fields", search for the field you want to have a default selection. Now when you click over that field, select the first icon (field settings) and select "Always select on value". The only issue is users will not be able to select multiple values but this will give you a default value pre-defined. I have tried using variables and etc but not much luck besides using the bookmark methodology and this one I have mentioned. I'd assume Qlik will have a capability like this in their next release as it is usually a basic capability in most business intelligence suites.
 New-Qlik
		
			New-Qlik
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		