Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fernandorech
Contributor
Contributor

using FirstSortedValue function with other source data

Hello,

I have two tables: client and phonecalls

clients table stores all clients

the phonecalls table stores all outgoing calls

my question is, how to insert on table's client the latest attempt phone call

Ex:

below the last_phone_call for "erik" should be "13-07-2019 11:00"

for "evan "should be "22-06-2019 10:00"

client table

IDNAMElast_phone_call
1erik 
2evan 

 

phonecalls table

id_clientphonecall_date
101-04-2019 15:00
205-04-2019 9:00
222-06-2019 10:00
113-07-2019 11:00

 

 

2 Replies
Frank_Hartmann
Master II
Master II

see attached qvw

hope this helps

SumitaKumari
Partner - Contributor II
Partner - Contributor II

Try this :

=Aggr(Max(phonecall_date),NAME)