The problem here is the quality of data isn't good in my tables, please ignore the previous tables. The unique identifier column actually isn't unique For example Unique ID 2 belongs to Ed and also to KK. SO,now when i want to see charges for Ed, The actual charges for Unique ID will be 20 but since KK is also using the Same ID, qlikview shows the total as 20 but will show charge of 20 in front of both names, KK and Ed. So first I want to join by Unique ID and then by email.
Emp Name Emp Email ID Unique Identifier Manager Office address
A abc_gmail.com 1 John New York
B abc1_gmail.com 2 Ed Houston
C abc2_gmail.com 3 Raj Dallas
D abc3_gmail.com 2 KK Jersey
Charges Unique Identifier emailID Division
10 3 abc2_gmail.com G
20 2 abc1_gmail.com O
30 4 L
40 3 abc2_gmail.com Z
Now here again the email id column also has many blanks in table 2. So wherever there is blank my manager is fine with showing double values but wherever the email ID is available he wants the exact value.