topic Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/880105#M989621 <HTML><HEAD></HEAD><BODY><P><BR />hey all i need help</P><P>i have this example in a pivot table</P><P></P><P>ID&nbsp;&nbsp;&nbsp; Volume</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>5&nbsp;&nbsp;&nbsp; x</P><P>6&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>7&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>8&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>9&nbsp;&nbsp;&nbsp;&nbsp; x</P><P></P><P>this table is filtered by a field , once i select on this field in the some ID doesn't belong to this field will not show in the table</P><P>Ex:</P><P>ID&nbsp;&nbsp;&nbsp; Volume </P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>6&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>8&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>9&nbsp;&nbsp;&nbsp;&nbsp; x</P><P></P><P>my request is to show them all</P><P></P><P>ID&nbsp;&nbsp;&nbsp; Volume </P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>5&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>6&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>7&nbsp;&nbsp;&nbsp; 0</P><P>8&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>9&nbsp;&nbsp;&nbsp;&nbsp; x</P><P></P><P>please help</P></BODY></HTML> Wed, 15 Jul 2015 13:01:51 GMT mario-sarkis 2015-07-15T13:01:51Z Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/880105#M989621 <HTML><HEAD></HEAD><BODY><P><BR />hey all i need help</P><P>i have this example in a pivot table</P><P></P><P>ID&nbsp;&nbsp;&nbsp; Volume</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>5&nbsp;&nbsp;&nbsp; x</P><P>6&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>7&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>8&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>9&nbsp;&nbsp;&nbsp;&nbsp; x</P><P></P><P>this table is filtered by a field , once i select on this field in the some ID doesn't belong to this field will not show in the table</P><P>Ex:</P><P>ID&nbsp;&nbsp;&nbsp; Volume </P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>6&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>8&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>9&nbsp;&nbsp;&nbsp;&nbsp; x</P><P></P><P>my request is to show them all</P><P></P><P>ID&nbsp;&nbsp;&nbsp; Volume </P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>5&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>6&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>7&nbsp;&nbsp;&nbsp; 0</P><P>8&nbsp;&nbsp;&nbsp;&nbsp; x</P><P>9&nbsp;&nbsp;&nbsp;&nbsp; x</P><P></P><P>please help</P></BODY></HTML> Wed, 15 Jul 2015 13:01:51 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/880105#M989621 mario-sarkis 2015-07-15T13:01:51Z Re: Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/880106#M989622 <HTML><HEAD></HEAD><BODY><P>Try disabling the option Suppress Zero-values and use an expression like sum(Volume)+sum({1}0)</P></BODY></HTML> Wed, 15 Jul 2015 13:21:09 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/880106#M989622 Gysbert_Wassenaar 2015-07-15T13:21:09Z