Create a Condition using two fields which are in separate tables
I want to create a condition using two tabels which are in separate tables. Let me elaborate. I have the following 3 tabels:
1. Sales Data: Containing Customer, Item Code and Sales Qty
2. Customer Data: Customer and Customer Group
3.Item Data: Item Code and Item Category
See attached Source Data and Qlikview Model.
I want to create a script that If the Customer Group is "Game" and the Item Category is "Sanware" , then this should be "Renewable" otherwise its "Non-Renewable" and this new field should be called Division. This
Because Item Category and Customer Group are in 2 seperate tables, how do I combine these 2 fields.