Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
shanky1907
Creator II
Creator II

Historical data & Last data status

Hello All,

I am going through an issue to represent Employee data about their trainings and completion status.

I have a simple data model with three table connected with EmpID & a master calender connected to Employee table with DOC(Date of last status change of one of the training completed).

So, in this case whenever such a month is selected in which their is no DOC for any employee, it shows blank on all Charts as Calender cant find any relation to the Month selected.

I want to change my Data model and give such condition that whenver any such empty data month is selected then it should show last available completion status.

Thanks to all in advance!

1 Reply
cristinapo
Contributor III
Contributor III

Hi, can you please paste a screenshot of the Table viewer?