Max date in data load and in chart

[Zahmed14]

Hello Guys , 

am new to qlik ,  i have hana model which i load data from ,  what i need is to get the latest date in data load and also in charts 

i wrote below but give me error that  PHD_CERT1 not found

PHD_CERT1 :
Load
"PARTNER",
"OBJNR",
"RECNTYPE",
"TXT04",
"BEZ30",
"ZZFULL_NAME_ENG",
"NATIO50",
"CHDAT",
"Contract_Count" ;

Max("CHDAT") as Maxdate Resident PHD_CERT1
Group By "OBJNR","PARTNER","TXT04","BEZ30","ZZFULL_NAME_ENG","NATIO50","Contract_Count";

SQL SELECT "PARTNER",
"OBJNR",
"RECNTYPE",
"TXT04",
"BEZ30",
"ZZFULL_NAME_ENG",
"NATIO50",
"Contract_Count",
"CHDAT"

FROM "_SYS_BIC"."XXX.projects.XXX_Datamart/CV_RECN"
where "RECNTYPE" = 'ZH12' and "ZZFULL_NAME_ENG" <> '' ;

Also please advise  how to write in chart function 

[Zahmed14]

data loaded succesfuly  should i do somthing next before doing the max function ?

[lironbaram]

and the table name is PHD_CERT1 ?

[Zahmed14]

i loaded data in PHD_CERt1  then i wrote max function and its working fine ... finaly he  can see the PHD_CERT1 

do i have put a relation between them in data manager or just put  max date in charts and tables directly  ?