topic Re: null values in QlikView https://community.qlik.com/t5/QlikView/null-values/m-p/1124364#M890943 <HTML><HEAD></HEAD><BODY><P>/dimension i can supress ...but expression iam not able to supresss</P></BODY></HTML> Wed, 17 Aug 2016 13:50:49 GMT raadwiptec 2016-08-17T13:50:49Z null values https://community.qlik.com/t5/QlikView/null-values/m-p/1124356#M890935 <HTML><HEAD></HEAD><BODY><P>how to avoid null values in an expression column?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/null-values/m-p/1124356#M890935 raadwiptec 2020-11-25T16:16:04Z Re: null values https://community.qlik.com/t5/QlikView/null-values/m-p/1124357#M890936 <HTML><HEAD></HEAD><BODY><P>Hi raadwiptec,</P><P></P><P>check this issue: <A href="https://community.qlik.com/thread/228204">Show date Dates with 0 value if data not available</A></P><P>that helps to finde solution for your issue, let me know if you need assistance</P><P></P><P>i hope that helps</P><P>beck</P></BODY></HTML> Wed, 17 Aug 2016 12:42:33 GMT https://community.qlik.com/t5/QlikView/null-values/m-p/1124357#M890936 beck_bakytbek 2016-08-17T12:42:33Z Re: null values https://community.qlik.com/t5/QlikView/null-values/m-p/1124358#M890937 <HTML><HEAD></HEAD><BODY><P>"Avoid" them in what way? Hide them, don't load them, change them to something like "missing" or prevent them? If you ask questions that are a bit more specific, you will get more accurate and useful answers.</P></BODY></HTML> Wed, 17 Aug 2016 12:49:44 GMT https://community.qlik.com/t5/QlikView/null-values/m-p/1124358#M890937 jonathandienst 2016-08-17T12:49:44Z Re: null values https://community.qlik.com/t5/QlikView/null-values/m-p/1124359#M890938 <HTML><HEAD></HEAD><BODY><P>either hide them or avoid them in the expression only</P></BODY></HTML> Wed, 17 Aug 2016 13:04:36 GMT https://community.qlik.com/t5/QlikView/null-values/m-p/1124359#M890938 raadwiptec 2016-08-17T13:04:36Z Re: null values https://community.qlik.com/t5/QlikView/null-values/m-p/1124360#M890939 <HTML><HEAD></HEAD><BODY><P>but nothing at the script level only at the expression level</P></BODY></HTML> Wed, 17 Aug 2016 13:05:46 GMT https://community.qlik.com/t5/QlikView/null-values/m-p/1124360#M890939 raadwiptec 2016-08-17T13:05:46Z Re: null values https://community.qlik.com/t5/QlikView/null-values/m-p/1124361#M890940 <HTML><HEAD></HEAD><BODY><P>raadwiptec,</P><P>you can use both in Script and in Expression, check above </P></BODY></HTML> Wed, 17 Aug 2016 13:10:13 GMT https://community.qlik.com/t5/QlikView/null-values/m-p/1124361#M890940 beck_bakytbek 2016-08-17T13:10:13Z Re: null values https://community.qlik.com/t5/QlikView/null-values/m-p/1124362#M890941 <HTML><HEAD></HEAD><BODY><P>What Chart object you are using here ? Any sample data or App you can attach ?</P></BODY></HTML> Wed, 17 Aug 2016 13:15:52 GMT https://community.qlik.com/t5/QlikView/null-values/m-p/1124362#M890941 vishsaggi 2016-08-17T13:15:52Z Re: null values https://community.qlik.com/t5/QlikView/null-values/m-p/1124363#M890942 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If you want Dimension null values to get excluded then go to Dimension Tab and Click on Dimension and Mark the "Suppress When Value is Null"</P><P></P><P>For Expression,</P><P></P><P>You should go to Presentation Tab and Mark the option which says "Suppress Zero-Values"</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Wed, 17 Aug 2016 13:18:55 GMT https://community.qlik.com/t5/QlikView/null-values/m-p/1124363#M890942 kaushiknsolanki 2016-08-17T13:18:55Z Re: null values https://community.qlik.com/t5/QlikView/null-values/m-p/1124364#M890943 <HTML><HEAD></HEAD><BODY><P>/dimension i can supress ...but expression iam not able to supresss</P></BODY></HTML> Wed, 17 Aug 2016 13:50:49 GMT https://community.qlik.com/t5/QlikView/null-values/m-p/1124364#M890943 raadwiptec 2016-08-17T13:50:49Z Re: null values https://community.qlik.com/t5/QlikView/null-values/m-p/1124365#M890944 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please share then sample Application, to understand your problem.</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Wed, 17 Aug 2016 13:53:15 GMT https://community.qlik.com/t5/QlikView/null-values/m-p/1124365#M890944 kaushiknsolanki 2016-08-17T13:53:15Z Re: null values https://community.qlik.com/t5/QlikView/null-values/m-p/1124366#M890945 <HTML><HEAD></HEAD><BODY><P>You have to give us more details of expression you are using and where you are getting nulls any screenshots please do attach ?</P></BODY></HTML> Wed, 17 Aug 2016 13:54:18 GMT https://community.qlik.com/t5/QlikView/null-values/m-p/1124366#M890945 vishsaggi 2016-08-17T13:54:18Z