topic Re: how to map field in QlikView

how to map field

Wed, 25 Nov 2020 16:16:04 GMT

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 .

Re: how to map field

sunny_talwar — Tue, 29 Mar 2016 14:03:09 GMT

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

Re: how to map field

engishfaque — Wed, 30 Mar 2016 03:43:38 GMT

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