topic Fixed dimension on pivot table in QlikView https://community.qlik.com/t5/QlikView/Fixed-dimension-on-pivot-table/m-p/510148#M190621 <HTML><HEAD></HEAD><BODY><P>Guys, I have a model where I own a grouping of products by area. I need to create a table that shows me the summation of these areas when I filter dates. however to filter a date that does not have record for all areas is necessary that a line appears for this area with zero value. The column description of the area can not be reduced by the filter.<OBJECT height="0" style="font-size: 10pt; line-height: 1.5em;" type="application/gas-events-bb" width="0"></OBJECT></P></BODY></HTML> Thu, 19 Dec 2013 18:31:02 GMT 2013-12-19T18:31:02Z Fixed dimension on pivot table https://community.qlik.com/t5/QlikView/Fixed-dimension-on-pivot-table/m-p/510148#M190621 <HTML><HEAD></HEAD><BODY><P>Guys, I have a model where I own a grouping of products by area. I need to create a table that shows me the summation of these areas when I filter dates. however to filter a date that does not have record for all areas is necessary that a line appears for this area with zero value. The column description of the area can not be reduced by the filter.<OBJECT height="0" style="font-size: 10pt; line-height: 1.5em;" type="application/gas-events-bb" width="0"></OBJECT></P></BODY></HTML> Thu, 19 Dec 2013 18:31:02 GMT https://community.qlik.com/t5/QlikView/Fixed-dimension-on-pivot-table/m-p/510148#M190621 2013-12-19T18:31:02Z Re: Fixed dimension in simple table https://community.qlik.com/t5/QlikView/Fixed-dimension-on-pivot-table/m-p/510149#M190622 <HTML><HEAD></HEAD><BODY><P>See attached qvw. Is that what you need?</P></BODY></HTML> Thu, 19 Dec 2013 18:53:17 GMT https://community.qlik.com/t5/QlikView/Fixed-dimension-on-pivot-table/m-p/510149#M190622 Gysbert_Wassenaar 2013-12-19T18:53:17Z Re: Fixed dimension in simple table https://community.qlik.com/t5/QlikView/Fixed-dimension-on-pivot-table/m-p/510150#M190623 <HTML><HEAD></HEAD><BODY><P>Sorry, I wrote simple table but I need do this on pivot table</P></BODY></HTML> Thu, 19 Dec 2013 18:58:43 GMT https://community.qlik.com/t5/QlikView/Fixed-dimension-on-pivot-table/m-p/510150#M190623 2013-12-19T18:58:43Z Re: Fixed dimension in simple table https://community.qlik.com/t5/QlikView/Fixed-dimension-on-pivot-table/m-p/510151#M190624 <HTML><HEAD></HEAD><BODY><P>Try sum(Value)+sum({&lt;TimeMonth=&gt;}0) and disable the option Suppress Zero-Values.</P></BODY></HTML> Thu, 19 Dec 2013 19:02:42 GMT https://community.qlik.com/t5/QlikView/Fixed-dimension-on-pivot-table/m-p/510151#M190624 Gysbert_Wassenaar 2013-12-19T19:02:42Z