topic Simple question - PivotTable showing all values in QlikView https://community.qlik.com/t5/QlikView/Simple-question-PivotTable-showing-all-values/m-p/235612#M86865 <HTML><HEAD></HEAD><BODY><P>hi</P><P>what you need to do is very simple</P><P>in the dimiensons tab you check the boxes 1.how all values , 2.supress when value is null , for the desired dimension</P><P>attach is an example</P></BODY></HTML> Wed, 10 Feb 2010 11:49:14 GMT lironbaram 2010-02-10T11:49:14Z Simple question - PivotTable showing all values https://community.qlik.com/t5/QlikView/Simple-question-PivotTable-showing-all-values/m-p/235611#M86864 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I have a simple pivot table - products on the Y axis, months(1-12) on the X axis and SUM(Sales) as the expression.</P><P>When displayed fully, no problem. Problem begings when user selects item(s) with no sales in a certain month - for instance, with sales only in 3 months. The pivot will show those 3 months only, while I want it to show all 12 months always, with zero. Supress zero values is not marked.</P><P>How can this be acheived?</P></BODY></HTML> Wed, 10 Feb 2010 11:34:29 GMT https://community.qlik.com/t5/QlikView/Simple-question-PivotTable-showing-all-values/m-p/235611#M86864 m4u 2010-02-10T11:34:29Z Simple question - PivotTable showing all values https://community.qlik.com/t5/QlikView/Simple-question-PivotTable-showing-all-values/m-p/235612#M86865 <HTML><HEAD></HEAD><BODY><P>hi</P><P>what you need to do is very simple</P><P>in the dimiensons tab you check the boxes 1.how all values , 2.supress when value is null , for the desired dimension</P><P>attach is an example</P></BODY></HTML> Wed, 10 Feb 2010 11:49:14 GMT https://community.qlik.com/t5/QlikView/Simple-question-PivotTable-showing-all-values/m-p/235612#M86865 lironbaram 2010-02-10T11:49:14Z Simple question - PivotTable showing all values https://community.qlik.com/t5/QlikView/Simple-question-PivotTable-showing-all-values/m-p/235613#M86866 <HTML><HEAD></HEAD><BODY><P>Thanks alot</P></BODY></HTML> Wed, 10 Feb 2010 13:54:32 GMT https://community.qlik.com/t5/QlikView/Simple-question-PivotTable-showing-all-values/m-p/235613#M86866 m4u 2010-02-10T13:54:32Z