topic conditional mapping in App Development

conditional mapping

Sandra5 — Fri, 11 Apr 2025 06:10:56 GMT

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

Re: conditional mapping

marcus_sommer — Fri, 11 Apr 2025 07:02:40 GMT

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

Re: conditional mapping

Sandra5 — Fri, 11 Apr 2025 07:54:10 GMT

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