Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 Vivek12
		
			Vivek12
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hey
I have a dashboard which has month selections in the filters. I need to show in a KPI what has been the growth rate of a parameter between the start date & the end date?
Can any body please help me on this? 
My expression is not working
(sum({[FB.Period]<{$(=Min([FB.Period]))}} Impressions)
/
sum({[FB.Period]>{$(=Min([FB.Period]))}} Impressions))
-1
 
					
				
		
 Or
		
			Or
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		You can't use greater than / less than with this part of the set analysis. Have a look at e.g.
https://community.qlik.com/t5/QlikView-App-Dev/Set-Analysis-for-Less-than-Equal/td-p/366270
 Vivek12
		
			Vivek12
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Thanks a lot for the revert
Can you please write the expression for me?
I got the issue with the usage of signs but seems like there's some issue with the min. function as well. 
Also do i need to use the getfieldselection as well to capture the minimun from the selcted values from the date filter?
 Vivek12
		
			Vivek12
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		You can ignore the growth formula and just help with providing the sum before the starting date of the date range in the filter selection
 Vivek12
		
			Vivek12
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		You can ignore the growth formula and just help with providing the sum before the starting date of the date range in the filter selection
