Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
i have data
| date | value | 
|---|---|
| 1/1/2011 | 20 | 
| 2/1/2011 | 40 | 
| 3/1/2011 | 50 | 
| 4/1/2011 | 60 | 
| 5/1/2011 | 70 | 
| 6/1/2011 | 80 | 
| 7/1/2011 | 90 | 
| 8/1/2011 | 200 | 
| 9/1/2011 | 10 | 
| ... | 
i need to use 2 calendar object. there are startdate and enddate
 
					
				
		
What if I upload it here.....
Let me know if you can open it and if it is any help for you.
Dennis.
 
					
				
		
Take a look at this QV-file I uploaded a while ago : http://community.qlik.com/qlikviews/1054
Maybe it contains what you need.
 
					
				
		
i cannot get your file
it's
 
					
				
		
Try this:
=Sum({$<date= {'<=$(=Date(vMaxDate))>=$(=Date(vMinDate))'} >} value))
 its_anandrjs
		
			its_anandrjs
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
See the attached sample file.
Let me know
HTH
Rgds
Anand
 
					
				
		
Thank you for all your answer ^^
i will try ...
 
					
				
		
What if I upload it here.....
Let me know if you can open it and if it is any help for you.
Dennis.
