Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
tan_chungkam
Contributor

To show full days of every month

Hi All,

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.

 

image.pngMy pivot table

image.pngMy Scripting

6 Replies
Channa
Contributor III

Re: To show full days of every month

include Null values under Tecnician

Channa
MVP
MVP

Re: To show full days of every month

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
tan_chungkam
Contributor

Re: To show full days of every month

Hi @jontydkpi ,

Thanks for the advice.

I already checked it but it still the same.

tan_chungkam
Contributor

Re: To show full days of every month

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.

image.png

Channa
Contributor III

Re: To show full days of every month

for that date there is no technican ..so it will show -

Channa
tan_chungkam
Contributor

Re: To show full days of every month

@Channa ,

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.

image.pngMy expected outcome