Discussion board where members can get started with Qlik Sense.
Please find attached my excel table and qvf files.
I have a pivot table as screenshot shown.
I would like to show full days of every month.
For e.g. it should show 1/1/2018 ~ 31/1/2018 instead of just show 1/1/2018 - 10/1/2018.
My pivot table
include Null values under Tecnician
Check the Include Zero Values option in Add-Ons | Data Handling and make sure that the calendar file has dates for January after the 10th.
Hi @jontydkpi ,
Thanks for the advice.
I already checked it but it still the same.
Hi @Channa ,
If i check that Null Value for Technician, there will be a '-' shown in the table.
It is not the outcome that i want for.
for that date there is no technican ..so it will show -
Of course i know there is no technician on those dates.
That's not the outcome that i want.
What i want is it should the dates even there is no technicians at the same time i don't want see there is a null value as the above screenshot.
Just for your clear understanding below is the outcome that i want.
My expected outcome