3 Replies Latest reply: Oct 4, 2017 11:46 AM by pradosh thakur RSS

    Join issue.

    qlik tech

      Hi,

       

      I have to make a join on a field(Account number) that has multiple values, I need to join and pick up an amount from the other table.

       

      Due to multiple occurances of account number I am getting the amount counted multiple times. How would I restrict the amount to show only once?

       

      I need to further calculations based on the account number.

       

      thanks.