Join issue.

[qliktech_uk]

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.

[swuehl]

Maybe don't join the tables, just keep them linked by account number.

[qliktech_uk]

But I get incorrect results when I make selections.

[pradosh_thakur]

which join are you exactly using ?

share sample data or app if possible.

regards

Pradosh