Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
 Akina0929
		
			Akina0929
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Community,
I want to implement below formulas in qlik
MTD Run Rate---MTD Days passed /total MTD days
YTD Run Rate--YTD Day passed / total YTD Days
team please help me to create expressions for above formulas
Thanks in Advance,
 
					
				
		
 vinieme12
		
			vinieme12
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		YTD
= sum({<Datefield={">=$(=Date(yearstart(Max(Datefield))))<=$(=Date(Max(Datefield)))"}>}Measurefield)
MTD
= sum({<Datefield={">=$(=Date(monthstart(Max(Datefield))))<=$(=Date(Max(Datefield)))"}>}Measurefield)
