https://community.qlik.com/t5/QlikView/Pivot-Table-Not-displaying-properly/m-p/1689798#M506951 <P>Hai,</P><P>I am using 3 pivot tables to display data monthly wise in my dash board with some common dimensions.</P><P>when there is no data available based on some filters, my tables are shrinking (not showing some months, because there are no records for the months).</P><P>instead of not showing the data, i want to show 0 records.</P><P>Could you please help me to rectify this issue!</P> Wed, 01 Apr 2020 10:58:33 GMT Bala99 2020-04-01T10:58:33Z https://community.qlik.com/t5/QlikView/Pivot-Table-Not-displaying-properly/m-p/1689798#M506951 <P>Hai,</P><P>I am using 3 pivot tables to display data monthly wise in my dash board with some common dimensions.</P><P>when there is no data available based on some filters, my tables are shrinking (not showing some months, because there are no records for the months).</P><P>instead of not showing the data, i want to show 0 records.</P><P>Could you please help me to rectify this issue!</P> Wed, 01 Apr 2020 10:58:33 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Not-displaying-properly/m-p/1689798#M506951 Bala99 2020-04-01T10:58:33Z https://community.qlik.com/t5/QlikView/Pivot-Table-Not-displaying-properly/m-p/1695920#M506952 <P>It would be most helpful if you can attach the QVW file or a sample QVW that would show the issue using sample data, little difficult to really pose much otherwise.</P><P>Regards,<BR />Brett</P> Wed, 22 Apr 2020 21:17:39 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Not-displaying-properly/m-p/1695920#M506952 Brett_Bleess 2020-04-22T21:17:39Z