Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
raadwiptec
Creator II
Creator II

mapping

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..

2 Replies
effinty2112
Master
Master

Hi,

Try

.

.

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

,'Past'

.

.



Cheers


Andrew

sunny_talwar

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?