Hello everyone,
I am new to qlikview development and I am stucked at this question , would appreciate your feedback,
I have two datasources ;
| Data Souce 1 |
| Ins No | Name |
| 450001 | Asım Akın |
| 450002 | Şeyma Can |
| 450003 | Ali Alkan |
| 450004 | Özsev Ateş |
| Data Source 2 |
| Ins No | Telex ID | Telex Num |
| 450001 | 4500011 | AB1 |
| 4500012 | AB2 |
| 4500013 | AB3 |
| 450002 | 4500021 | BC1 |
| 4500022 | BC2 |
| 450003 | 4500031 | CD1 |
| 450004 | 4500041 | DE1 |
| 4500042 | DE2 |
I need to create a table showing Ins No, Name, and Telex Num of the Max(TelexID) for that Ins No like in the table below,
| Ins No | Kişi Adı | Telex Num |
| 450001 | Asım Akın | AB3 |
| 450002 | Şeyma Can | BC2 |
| 450003 | Ali Alkan | CD1 |
| 450004 | Özsev Ateş | DE2 |
I could not get that Telex Num to the table chart. Can you show me how to do it?
Thank you
