Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-09-19 01:25 AM

Join validation

Dear All,

I have 2 table and I don't have any primary key between both the tables...

And its must to join both the table in this way by which I get correct validation result...

Please find the attached files for details..

I want salary should come correct after joining...

Please reply..

Rahul

Lest_Test.qvw
10 KB
255 Views
0 Likes
4 Replies
tresesco
MVP
MVP
‎2014-09-19 01:40 AM

This is how join works. To get your desired result, just keep the tables associated (No join).

183 Views
anbu1984
Master III
Master III
‎2014-09-19 01:40 AM

Try this

=Sum(Aggr(Max(DISTINCT Salary),ID))

183 Views
Anonymous
Not applicable
‎2014-09-19 01:40 AM
Author

in the expression:

Sum(Aggr(Salary, NAME))

183 Views
0 Likes
Not applicable
‎2014-09-19 01:41 AM
Author

If you do not have any business rule on which these 2 table will be joined, then there is no way to get the expected results.

I would request you to redefine the way you want to link these tables.

Thanks,

Singh

183 Views