topic Re: apply map in QlikView

apply map

raadwiptec — Wed, 25 Nov 2020 16:16:04 GMT

For ex: I do a apply map from the invoice rate table

Mapping Load,

Year & Month

Invoice Rate

xxxxx

so based on my year and month for ex if it 2017 01 then invoice rate would be used and multipllied with the end column

for 2016 12 the specific rate would be multiplied.

Now i want to apply 2017 rates all the previous years.

any sugg

MayilVahanan — Fri, 17 Feb 2017 10:22:12 GMT

So 201701 invoice rate need to apply for 201601, similarly for 201702 invoice rate need to apply for 201602. in that case, try like below

MapInvoiceRate:

Mapping load Month, InvoiceRate from sourcetable where Year = 2017;

In applymap state,

Applymap('MapInvoiceRate', Month)

avinashelite — Fri, 17 Feb 2017 10:34:00 GMT

could you please explain with an example that would be better to understand