topic How to make Pivot Table structure fixed irrespective of data available? in QlikView https://community.qlik.com/t5/QlikView/How-to-make-Pivot-Table-structure-fixed-irrespective-of-data/m-p/840313#M295295 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have attached snapshot here.In that table even System Type= Client &amp; Server Owner= Business are blank then it shoiuld show '0' instead shrinking the table. Means <SPAN style="font-size: 13.3333330154419px;">System Type &amp; Server Owner Column should always be fixed&nbsp; irrespective of available data.I will also share a sample of data I am also sharing snapshot when it shrinks and it needs to be avoided (ipin2.png)</SPAN></P><P></P><P></P><P></P><P></P><P>Thanks in advance</P></BODY></HTML> Tue, 28 Apr 2015 11:52:19 GMT Anonymous 2015-04-28T11:52:19Z How to make Pivot Table structure fixed irrespective of data available? https://community.qlik.com/t5/QlikView/How-to-make-Pivot-Table-structure-fixed-irrespective-of-data/m-p/840313#M295295 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have attached snapshot here.In that table even System Type= Client &amp; Server Owner= Business are blank then it shoiuld show '0' instead shrinking the table. Means <SPAN style="font-size: 13.3333330154419px;">System Type &amp; Server Owner Column should always be fixed&nbsp; irrespective of available data.I will also share a sample of data I am also sharing snapshot when it shrinks and it needs to be avoided (ipin2.png)</SPAN></P><P></P><P></P><P></P><P></P><P>Thanks in advance</P></BODY></HTML> Tue, 28 Apr 2015 11:52:19 GMT https://community.qlik.com/t5/QlikView/How-to-make-Pivot-Table-structure-fixed-irrespective-of-data/m-p/840313#M295295 Anonymous 2015-04-28T11:52:19Z Re: How to make Pivot Table structure fixed irrespective of data available? https://community.qlik.com/t5/QlikView/How-to-make-Pivot-Table-structure-fixed-irrespective-of-data/m-p/840314#M295296 <HTML><HEAD></HEAD><BODY><P>the sample.xlsx that you have provided doesn't have IPINS_Date field in it. In addition what are the formulas you are using for each of your expressions?</P></BODY></HTML> Tue, 28 Apr 2015 12:12:17 GMT https://community.qlik.com/t5/QlikView/How-to-make-Pivot-Table-structure-fixed-irrespective-of-data/m-p/840314#M295296 sunny_talwar 2015-04-28T12:12:17Z Re: How to make Pivot Table structure fixed irrespective of data available? https://community.qlik.com/t5/QlikView/How-to-make-Pivot-Table-structure-fixed-irrespective-of-data/m-p/840315#M295297 <HTML><HEAD></HEAD><BODY><P>Thanks for reply</P><P></P><P>IPINS date is Start Time only.....in expression only count is used with certain filters</P></BODY></HTML> Tue, 28 Apr 2015 12:19:39 GMT https://community.qlik.com/t5/QlikView/How-to-make-Pivot-Table-structure-fixed-irrespective-of-data/m-p/840315#M295297 Anonymous 2015-04-28T12:19:39Z