Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor III

Issue with Pivot table

Hi All,

Example: I have 4 Years data 2014,2015,2016,2017.. I want Display Only Current Year Month wise Sales renaming years want to display years wise .. If Fiscal year is Starts from July to June .. Now Current month is May now i want display June Month as Empty in Pivot as Current Month June See Reference date:

Current Month Year in Pivot:


July  Aug  Sep  Oct  Nov  DEC    Jan  Feb   Mar   Apr   May   Jun   AVG

100  200   300  400  500   600     700   800   900    1000 1100    -     6600/12=550

Year to Month in Pivot.png

Can you please help me asap guys..