Discussion Board for collaboration on QlikView Scripting.
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.
Maybe don't join the tables, just keep them linked by account number.
But I get incorrect results when I make selections.
which join are you exactly using ?
share sample data or app if possible.