3 Replies Latest reply: Apr 21, 2016 2:54 AM by Omer Ozdemir RSS

    Straight table based on possible values of a field

    Omer Ozdemir

      Hi,

       

      I have just started using Qlikview and have a question . I have a straight table chart based on salesorders with an sum of salesamount per customer.

      I also have a seperated field named products with no connection to salesorders field.

       

      I want to to show the only barcodes selected in Products field. Maybe it possible  with conditional expression or modifing expression but haven't find the right solution yet .

       

      Anyone who can show the way ? Thanks.

       

      Ps:I can't link fields since it causes a circular reference in datamodel .

       

       

      Products:

      Barcode

      Product Name

       

      SalesOrders:

      Barcode

      Customer

      Amount