Pivot datasource - how to set empty dates ???

Question

Hi,
We use the pivot table with a datasource that has dates data points. Sometimes these date values can be empty. Currently we generate the json datasource as follows ( the date field name is"f1346623" ):
Empty date have a value of "".[
{
    "f1346623" : "06.15.2017",
    "f1" : 1
},
{
    "f1346623" : "06.01.2017",
    "f1" : 1
},
{
    "f1346623" : '',
    "f1" : 1
},
{
    "f1346623" : '',
    "f1" : 1
}
];
This creates a rendering problem in the pivot control. If the dataset has dates that are empty, the pivot grid does not render at all. If we filter out the empty dates then it will work. This also breaks the grouping function.How can we set empty date values in our datasource so the pivot works correctly?We tried setting the value to null , the rendering works but then it shows null in the grid which is NOT user friendly. We tried setting the emptyCellsTextContent property but null is still displayed.You can see an example of this at http://www.tgmt-systems.com/syncFusion/index.jsp . It will not work by default but if you filter out the empty dates in the 'Due Date' field, it will work.Looking forward to your reply.

Manikandan Murugesan · Answer

Hi Thierry, 

Please set “null” or “undefined” to the empty dates. You can also hide those headers by using the "showHeaderWhenEmpty" property in the “dataSourceSettings”. Please refer the code example below. 
 
Code Example: 




var pivotObj = new ej.pivotview.PivotView({ 
  dataSourceSettings: { 
    showHeaderWhenEmpty: false, 
  } 
}); 
pivotObj.appendTo('#PivotView'); 
 
Meanwhile, we have prepared a sample for your reference. Please find it from below link. 
Sample: https://stackblitz.com/edit/j7gzfk 
 
Please see the following UG document for more information on the "showHeaderWhenEmpty " property. 
Document: https://ej2.syncfusion.com/javascript/documentation/pivotview/how-to/hide-empty-headers/ 
 
Please let us know if you have any concerns. 
 
Regards,  
Manikandan

Thierry Tremblay · Answer

Thank you, that did help. I have a follow-up question.Instead of hiding null - undefined values, would it be possible to show them has an empty string??If so, how can this be done?Thanks.

Manikandan Murugesan · Answer

Hi Thierry, 

To display null headers as an empty string, use the localization option. Please refer the example code below. 
 
Code Example: 




var L10n = ej.base.L10n; 
L10n.load({ 
  'en-US': { 
    pivotview: { 
      null: '', 
    }, 
  }, 
}); 
 
Meanwhile, we have prepared a sample for your reference. Please find it from below link. 
Sample: https://stackblitz.com/edit/j7gzfk-yp5286 
 
Please see the following UG document for more information on the "localization " option. 
Document: https://ej2.syncfusion.com/javascript/documentation/pivotview/globalization-and-localization/#loading-translations 
 
Please let us know if you have any concerns. 
 
Regards, 
Manikandan

Thierry Tremblay · Answer

This is perfect! Thank you very much

Manikandan Murugesan · Answer

Hi Thierry, 
 
Please let us know if you have any other queries. We are always happy to assist you. 
 
Regards, 
Manikandan