Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
MikeD1
Partner - Contributor II
Partner - Contributor II

Null date in join table

Hi, I have two table

Table1:

Date,

Agent,

hours.

Table2: 

Date

Agent,

worklog.

The first table contains the hours that must be worked by the agent per day.

The second one contains the hours effectively worked every day.

I have some null values in the second table (when the agent does not record the worked time).

I need to create a graph with the two hours compared.

I've tried with some master calendar without success and also with a bridge table but I'm not able to do it.

Thanks in advance community.

 

0 Replies