Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Dates in Pivot Tables

Good Morning, 

I am working with sales data from our ERP (SAP). I am wanting to create a Pivot with total sales per month per team member. However, the data is for each individual date and not combined into months. Can you combine the dates into the months like January 2019 in the Pivot table itself? If not what would be the script to convert it on data load? 

1 Reply
MVP & Luminary
MVP & Luminary

Re: Dates in Pivot Tables

I suggest to create a master-calendar and to use whose period-fields: How-to-use-Master-Calendar-and-Date-Values.

- Marcus