topic Re: mapping in QlikView

mapping

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

Hi Iam trying to apply map as below. i get good results.

If(ApplyMap('Invoice Mapping',[invoices ])='158964'

,'Future'

,If(ApplyMap('Purchased Mapping',[Invoices]) ='158965'

,'Past'

)

)) as [Group],

My issue i want to add another invoice number for purchase mapping.. for ex as below

If(ApplyMap('Invoice Mapping',[invoices ])='158964'

,'Future'

,If(ApplyMap('Purchased Mapping',[Invoices]) ='158965','125698'

,'Past'

)

)) as [Group],

but this does work as it shows script error.. how to provide 2 invoice numbers in this situations..

Re: mapping

effinty2112 — Fri, 07 Oct 2016 10:12:00 GMT

Hi,

Try

,If(Match(ApplyMap('Purchased Mapping',[Invoices]),'158965','125698')

,'Past'

Cheers

Andrew

Re: mapping

sunny_talwar — Fri, 07 Oct 2016 11:23:33 GMT

Its strange that you are using ApplyMap with if. Why don't you just map it correctly to past or future? Can you share a sample to see what exactly are you trying to do here?