3 Replies Latest reply: Mar 23, 2015 10:01 AM by Nayan Lalla RSS

    Create a Condition using two fields which are in separate tables

    Nayan Lalla

      Hi

       

      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.

       

      kind regards

      Nayan