2 Replies Latest reply: Aug 7, 2018 8:46 PM by Fabrizio Anzolin RSS

    How to show data results from a table that links to a query on another table.

    Fabrizio Anzolin

      Good morning, I am pretty new to Qliksense and I have difficulties in obtaining some results from a series of Dimensions. I'll try to explain the challenge I am facing.

       

      I have

       

      1 Dimension that contains a series of reference numbers (Transactions reference)

      1 Dimension that contains invoice details (charge codes)

      1 Dimension that contains invoice numbers

       

      I need to extract the reference numbers that are linked to 1 or more invoices that DO NOT contain a specific Charge Code/s (XYW) but contains many others.

       

      I am unable to find a way to "eliminate" from the report the invoices that contains the specific charge code and are linked to their relevant reference number.

       

      The end result would be to see only the reference numbers that are linked to invoices that DO NOT contain the specific charge code.

       

      Thanks in advance for your help and assistance.

      Fabrizio