Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to map field

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 .

2 Replies
sunny_talwar

May be create a Fiscal Year calendar: Fiscal and Standard Calendar generation

engishfaque
Specialist III
Specialist III

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