Pivot Table All Dates in a Range With or Without Data

[cathysmith]

Hello!  

I need some help on creating a pivot table based on a StartDate and an EndDate. The columns should display all dates within the date range and the rows are the count of clients that have a date_added for each date.  Currently I'm only getting dates that have clients.  If the date does not have a client it does not display at all.  

Here is an example of what I'm looking for:
StartDate: 1/1/2019
EndDate  : 1/5/2019

Results:

Dates                      1/1/2019    1/2/2019    1/3/2019    1/4/2019    1/5/2019
Client Count            30                  5                    0                    0                   50

[lorenzoconforti]

Hi

I would implement a master calendar (always good to have when you are working with dates); then in your pivot table enable null and blank values; see attached

Lorenzo

[Madhab77]

Hi Loren,

In this Pivot table, how can we achieve the functionality to have button or drop down selection for Ranges, like Last 10 days, Next 10 days, Last Month and Current Month?

Thanks in Advance,

Madhab Sikder

[lorenzoconforti]

You could either implement a master calendar or use a date range picker object:

https://community.qlik.com/t5/QlikView-Scripting/Creating-A-Master-Calendar/td-p/341286

https://help.qlik.com/en-US/sense/April2020/Subsystems/Hub/Content/Sense_Hub/Visualizations/Dashboar...