Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
qliktech_uk
Contributor III
Contributor III

Join issue.

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.

3 Replies
swuehl
MVP
MVP

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

qliktech_uk
Contributor III
Contributor III
Author

But I get incorrect results when I make selections.

pradosh_thakur
Master II
Master II

which join are you exactly using ?

share sample data or app if possible.

regards

Pradosh

Learning never stops.