Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

combine if with applymap

Hi guys, hope you can help me:


Load BNR,


     Resident X;


Load KNR,


     Resident Y;


Load BNR,


Resident Z;

My Problem:

In T2: has each of KNR with WildMatch (DE7011*) one Seller,

     And each DE7011* Nr, hast several BNR (Bills), but the bills of the KNR, arent connected with seller.

So how can I applyMap to the seller with BNR OF KNR ?

How can I tell qlikview, that: every BNR has one seller, if you dont know it, look it in KNR and summit

Tags (3)
Community Browser