topic Show results with zero (not null) in pivot table in QlikView https://community.qlik.com/t5/QlikView/Show-results-with-zero-not-null-in-pivot-table/m-p/401966#M1165053 <HTML><HEAD></HEAD><BODY><P>Hi!&nbsp; </P><P></P><P>I´m trying to display a pivot table that has a column "Quantity" with zero 0 in it.</P><P>When displaying the data through a table box I can see all the rows including thoose that have a 0 in column "Quantity".</P><P></P><P>But when diplaying the same in a pivot table all rows are shown except thoose that have 0 in column "Quantity"....</P><P></P><P>Please help me to display all rows.</P><P></P><P>Thanks in advance. </P></BODY></HTML> Mon, 05 Nov 2012 11:59:35 GMT 2012-11-05T11:59:35Z Show results with zero (not null) in pivot table https://community.qlik.com/t5/QlikView/Show-results-with-zero-not-null-in-pivot-table/m-p/401966#M1165053 <HTML><HEAD></HEAD><BODY><P>Hi!&nbsp; </P><P></P><P>I´m trying to display a pivot table that has a column "Quantity" with zero 0 in it.</P><P>When displaying the data through a table box I can see all the rows including thoose that have a 0 in column "Quantity".</P><P></P><P>But when diplaying the same in a pivot table all rows are shown except thoose that have 0 in column "Quantity"....</P><P></P><P>Please help me to display all rows.</P><P></P><P>Thanks in advance. </P></BODY></HTML> Mon, 05 Nov 2012 11:59:35 GMT https://community.qlik.com/t5/QlikView/Show-results-with-zero-not-null-in-pivot-table/m-p/401966#M1165053 2012-11-05T11:59:35Z Re: Show results with zero (not null) in pivot table https://community.qlik.com/t5/QlikView/Show-results-with-zero-not-null-in-pivot-table/m-p/401967#M1165056 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>Just toggle checkbox: Chart Preferences-&gt;Presentation tab-&gt;Supress zero-values</P></BODY></HTML> Mon, 05 Nov 2012 12:41:01 GMT https://community.qlik.com/t5/QlikView/Show-results-with-zero-not-null-in-pivot-table/m-p/401967#M1165056 whiteline 2012-11-05T12:41:01Z Re: Show results with zero (not null) in pivot table https://community.qlik.com/t5/QlikView/Show-results-with-zero-not-null-in-pivot-table/m-p/401968#M1165058 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>Nice, but I still have a problem with theese values cause now I can see values as null that are acually not null...</P><P></P><P><IMG __jive_id="24642" class="jive-image" alt="Capture.PNG" src="https://community.qlik.com/legacyfs/online/24642_Capture.PNG" /></P><P></P><P>When I click an article it says that the total is 2 464, but the expression says null....</P><P>Why do I get null when if it´s not? Or is it? <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Thanks in advance.</P></BODY></HTML> Mon, 05 Nov 2012 14:04:57 GMT https://community.qlik.com/t5/QlikView/Show-results-with-zero-not-null-in-pivot-table/m-p/401968#M1165058 2012-11-05T14:04:57Z Re: Show results with zero (not null) in pivot table https://community.qlik.com/t5/QlikView/Show-results-with-zero-not-null-in-pivot-table/m-p/401969#M1165059 <HTML><HEAD></HEAD><BODY><P>Post your expression.</P><P>And the screenshot of data model (Table Viewer) if it's not a secret.</P></BODY></HTML> Mon, 05 Nov 2012 14:28:09 GMT https://community.qlik.com/t5/QlikView/Show-results-with-zero-not-null-in-pivot-table/m-p/401969#M1165059 whiteline 2012-11-05T14:28:09Z