conditional mapping

[Sandra5]

Hello,

I hope you guys can help me with this problem. Usually, I can find what I'm looking for in existing questions, but not this time.

I'm using QlikSense desktop version. I have an App where I need to look at payments that we receive. I'm using mapping in the editor, looks like this:

[IBANMapping]:
MAPPING LOAD * INLINE
[
IBANMapping-FROM,IBANMapping-TO
AT71xxxxx,CustomerA
AT83xxxxx,CustomerB
AT94xxxxx,CustomerC

Now the problem is, there is one IBAN that could be two different customers. The only way to keep them apart is by the amount of money (loaded as [Betrag]) they paid. So if it's less than 5K it's CustomerX and if it's higher, it's CustomerY.

Is there any way to include that into the loading script? I'm stuck here, unfortunately.

Kind regards,

Sandra

[marcus_sommer · Accepted solution]

You may add a simple 0/1 information to your lookup-value, like:

[IBANMapping]:
MAPPING LOAD * INLINE [
IBANMapping-FROM,IBANMapping-TO
AT71xxxxx_0,CustomerA1
AT71xxxxx_1,CustomerA2
AT83xxxxx_1,CustomerB
AT94xxxxx_1,CustomerC

and then including the querying within the call, like:

applymap('IBANMapping', IBAN & '_' &
   if(IBAN = 'AT71xxxxx', if(Amount < 10000, 0, 1), 1), 'Default') as X

[Sandra5]

Thank you so much! That worked perfectly. You made my day 🙂