Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
qliktech_uk
New 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.

Tags (1)
3 Replies
MVP
MVP

Re: Join issue.

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

Highlighted
qliktech_uk
New Contributor III

Re: Join issue.

But I get incorrect results when I make selections.

pradosh_thakur
Honored Contributor II

Re: Join issue.

which join are you exactly using ?

share sample data or app if possible.

regards

Pradosh

Learning never stops.