Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
I have a Inline Table like this
Invoicetable:
LOAD * Inline [
Customer, Invoice Amount , InvoiceDate
Customer A, 1200 , 3/12/2012
Customer B, 1100 , 5/30/2013
Customer C, 1400 ,10/27/2012
Customer D, 1150 ,12/12/2014
];
and i have a FiscalCalender .
I need to map the InvoiceDate column of InvoiceTable with Year (column name) of Fiscal Calender .
So please suggest me , how do i go .
Thanks .
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		May be create a Fiscal Year calendar: Fiscal and Standard Calendar generation
 engishfaque
		
			engishfaque
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Dear Gautam,
Please go through listed below link,
Don't join - use Applymap instead
http://www.learnqlickview.com/applymap-function-in-qlikview/
Kind regards,
Ishfaque Ahmed
