topic Show null values in Straight Table chart in QlikView https://community.qlik.com/t5/QlikView/Show-null-values-in-Straight-Table-chart/m-p/174833#M43499 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>can you tell me how I can make the straight table show all the values and not hide nulls?</P><P>The dimensions are CustomerID and PurchaseDate. The expression is PurchaseValue.</P><P>The table shows only those intersections of CustomerID and PurchaseDate where any PurchaseValue exists. When I set the SHOW ALL VALUES flag for CustomerID Qlikview stops responding and takes the CPU at maximum. I tried to leave it like this for the night but Windows all in all gave the Low Virtual Memory error and so stopped Qlikview.</P><P>Is there any other way to display these customerids? Or can I at least create 0 values in the purchasevalue field for the non existent intersections of customerid and purchasedate?</P><P>Thanks.</P><P>Valera</P></BODY></HTML> Fri, 04 Dec 2009 00:32:30 GMT Anonymous 2009-12-04T00:32:30Z Show null values in Straight Table chart https://community.qlik.com/t5/QlikView/Show-null-values-in-Straight-Table-chart/m-p/174833#M43499 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>can you tell me how I can make the straight table show all the values and not hide nulls?</P><P>The dimensions are CustomerID and PurchaseDate. The expression is PurchaseValue.</P><P>The table shows only those intersections of CustomerID and PurchaseDate where any PurchaseValue exists. When I set the SHOW ALL VALUES flag for CustomerID Qlikview stops responding and takes the CPU at maximum. I tried to leave it like this for the night but Windows all in all gave the Low Virtual Memory error and so stopped Qlikview.</P><P>Is there any other way to display these customerids? Or can I at least create 0 values in the purchasevalue field for the non existent intersections of customerid and purchasedate?</P><P>Thanks.</P><P>Valera</P></BODY></HTML> Fri, 04 Dec 2009 00:32:30 GMT https://community.qlik.com/t5/QlikView/Show-null-values-in-Straight-Table-chart/m-p/174833#M43499 Anonymous 2009-12-04T00:32:30Z Show null values in Straight Table chart https://community.qlik.com/t5/QlikView/Show-null-values-in-Straight-Table-chart/m-p/174834#M43500 <HTML><HEAD></HEAD><BODY><P>OK, the problem is solved by simply unchecking <I>Suppress Zero-Values</I> and <I>Suppress Missing</I> in the Presentation tab of the chart's properties. So, now I have all the possible customer and date intersections even if some purchase values don't exist for them.</P></BODY></HTML> Fri, 04 Dec 2009 14:28:34 GMT https://community.qlik.com/t5/QlikView/Show-null-values-in-Straight-Table-chart/m-p/174834#M43500 Anonymous 2009-12-04T14:28:34Z