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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
raadwiptec
Creator II
Creator II
‎2016-10-07 06:03 AM

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

408 Views
0 Likes
2 Replies
effinty2112
Master
Master
‎2016-10-07 06:12 AM

Hi,

Try

.

.

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

,'Past'

.

.



Cheers


Andrew

311 Views
sunny_talwar
MVP
MVP
‎2016-10-07 07:23 AM

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?

311 Views