Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
New Contributor

Concatenate different tables and show null vales in chart


I am trying to merge 2 tables.

Specifically in the first excel there are specific dates that i have data regarding the time worked.

In the second excel i have a calendar with all dates (including those that no work was made).

I want to create a chart where, when i choose a month and a specific worker i want to see for the dates that no work was performed 0 hours and for the other days the times worked according to table 1.

Unfortunately till now when i choose a worker the chart shows only the specific date of the month that he worked and no 0 values for the days he didn' t work.

Thanxs in advance