topic Removing rows with 'Null' values from Chart (Straight Table) in QlikView https://community.qlik.com/t5/QlikView/Removing-rows-with-Null-values-from-Chart-Straight-Table/m-p/193876#M590026 <HTML><HEAD></HEAD><BODY><P>Thanks for the suggestions!</P></BODY></HTML> Tue, 12 Jan 2010 14:33:15 GMT 2010-01-12T14:33:15Z Removing rows with 'Null' values from Chart (Straight Table) https://community.qlik.com/t5/QlikView/Removing-rows-with-Null-values-from-Chart-Straight-Table/m-p/193873#M590023 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>Is it possible to filter out (i.e. not display) rows which contain a null in a specific column in a Straight Table chart?</P><P>I have a situation where I'm getting a duplicate row (with a null in a Value column) for each row of valid data. I've been unsuccessful in identifying the cause so this leads to my question above.</P><P>All help and suggestions are appreciated.</P><P>G</P></BODY></HTML> Mon, 21 Dec 2009 20:15:26 GMT https://community.qlik.com/t5/QlikView/Removing-rows-with-Null-values-from-Chart-Straight-Table/m-p/193873#M590023 2009-12-21T20:15:26Z Removing rows with 'Null' values from Chart (Straight Table) https://community.qlik.com/t5/QlikView/Removing-rows-with-Null-values-from-Chart-Straight-Table/m-p/193874#M590024 <HTML><HEAD></HEAD><BODY><P>I would not artificially filter data from being displayed. When they are duplicated then you should cleanse your database. Have you tried a DISTINCT Load of the data, or simply do not load them from the base-system?</P><P>Peter</P></BODY></HTML> Tue, 29 Dec 2009 22:16:29 GMT https://community.qlik.com/t5/QlikView/Removing-rows-with-Null-values-from-Chart-Straight-Table/m-p/193874#M590024 prieper 2009-12-29T22:16:29Z Removing rows with 'Null' values from Chart (Straight Table) https://community.qlik.com/t5/QlikView/Removing-rows-with-Null-values-from-Chart-Straight-Table/m-p/193875#M590025 <HTML><HEAD></HEAD><BODY><P>If you want to keep the null-value-in-row data but just not see it in the chart, you can always try:</P><P></P><P>Settings for Selected Dimension</P><P>Suppress When Value Is Null</P><BR /><BR /></BODY></HTML> Wed, 30 Dec 2009 00:03:18 GMT https://community.qlik.com/t5/QlikView/Removing-rows-with-Null-values-from-Chart-Straight-Table/m-p/193875#M590025 2009-12-30T00:03:18Z Removing rows with 'Null' values from Chart (Straight Table) https://community.qlik.com/t5/QlikView/Removing-rows-with-Null-values-from-Chart-Straight-Table/m-p/193876#M590026 <HTML><HEAD></HEAD><BODY><P>Thanks for the suggestions!</P></BODY></HTML> Tue, 12 Jan 2010 14:33:15 GMT https://community.qlik.com/t5/QlikView/Removing-rows-with-Null-values-from-Chart-Straight-Table/m-p/193876#M590026 2010-01-12T14:33:15Z