topic Re: Supress Null Values in Expression in QlikView https://community.qlik.com/t5/QlikView/Supress-Null-Values-in-Expression/m-p/951855#M958769 <HTML><HEAD></HEAD><BODY><P>Anyone has ever faced this kind of thing.</P><P>Kindly help.</P></BODY></HTML> Fri, 06 Nov 2015 13:18:51 GMT 2015-11-06T13:18:51Z Supress Null Values in Expression https://community.qlik.com/t5/QlikView/Supress-Null-Values-in-Expression/m-p/951854#M958768 <HTML><HEAD></HEAD><BODY><P>Hi Experts</P><P></P><P>I need to suppress Null Values in Expression.</P><P></P><P>PFA.</P><P></P><P>Regards</P><P>Eric Paul </P></BODY></HTML> Fri, 06 Nov 2015 09:13:17 GMT https://community.qlik.com/t5/QlikView/Supress-Null-Values-in-Expression/m-p/951854#M958768 2015-11-06T09:13:17Z Re: Supress Null Values in Expression https://community.qlik.com/t5/QlikView/Supress-Null-Values-in-Expression/m-p/951855#M958769 <HTML><HEAD></HEAD><BODY><P>Anyone has ever faced this kind of thing.</P><P>Kindly help.</P></BODY></HTML> Fri, 06 Nov 2015 13:18:51 GMT https://community.qlik.com/t5/QlikView/Supress-Null-Values-in-Expression/m-p/951855#M958769 2015-11-06T13:18:51Z Re: Supress Null Values in Expression https://community.qlik.com/t5/QlikView/Supress-Null-Values-in-Expression/m-p/951856#M958770 <HTML><HEAD></HEAD><BODY><P>I doubt, that you can do, becoz same expression is having value under another column...</P></BODY></HTML> Fri, 06 Nov 2015 13:22:44 GMT https://community.qlik.com/t5/QlikView/Supress-Null-Values-in-Expression/m-p/951856#M958770 Anonymous 2015-11-06T13:22:44Z Re: Supress Null Values in Expression https://community.qlik.com/t5/QlikView/Supress-Null-Values-in-Expression/m-p/951857#M958771 <HTML><HEAD></HEAD><BODY><P>Does it have a workaround</P><P>Nothing is impossible.</P><P>Yes, there are some limitations for that we have workarounds.</P><P>I've tried this thing. Now, I just have to supress the Null Values.</P></BODY></HTML> Fri, 06 Nov 2015 13:33:30 GMT https://community.qlik.com/t5/QlikView/Supress-Null-Values-in-Expression/m-p/951857#M958771 2015-11-06T13:33:30Z Re: Supress Null Values in Expression https://community.qlik.com/t5/QlikView/Supress-Null-Values-in-Expression/m-p/951858#M958772 <HTML><HEAD></HEAD><BODY><P>Hi Eric, the expressions will be repeated for each vertical dimension, If you can't get a better answer, a workaround can be to reproduce the relation between Test and expressions in script and only only expresions checking these values.</P><P></P><P>Please check attachment to get the idea.</P></BODY></HTML> Fri, 06 Nov 2015 13:38:38 GMT https://community.qlik.com/t5/QlikView/Supress-Null-Values-in-Expression/m-p/951858#M958772 rubenmarin 2015-11-06T13:38:38Z Re: Supress Null Values in Expression https://community.qlik.com/t5/QlikView/Supress-Null-Values-in-Expression/m-p/951859#M958773 <HTML><HEAD></HEAD><BODY><P>You could make the show of the column conditional based on the sum, or you could put zeros in by doing something like this in each expression:</P><P>=if(valuelist('ABC', 'XYZ')='XYZ',ALT(sum(Amount)),0)</P></BODY></HTML> Fri, 06 Nov 2015 13:40:17 GMT https://community.qlik.com/t5/QlikView/Supress-Null-Values-in-Expression/m-p/951859#M958773 roger_stone 2015-11-06T13:40:17Z Re: Supress Null Values in Expression https://community.qlik.com/t5/QlikView/Supress-Null-Values-in-Expression/m-p/951860#M958774 <HTML><HEAD></HEAD><BODY><P>Thanks for the Reply.</P><P>But still the same result. I am not able to suppress Zeros.</P></BODY></HTML> Fri, 06 Nov 2015 14:14:25 GMT https://community.qlik.com/t5/QlikView/Supress-Null-Values-in-Expression/m-p/951860#M958774 2015-11-06T14:14:25Z Re: Supress Null Values in Expression https://community.qlik.com/t5/QlikView/Supress-Null-Values-in-Expression/m-p/951861#M958775 <HTML><HEAD></HEAD><BODY><P>You can do it from back end like attached.</P><P></P><P>See the attached application</P></BODY></HTML> Fri, 06 Nov 2015 14:14:26 GMT https://community.qlik.com/t5/QlikView/Supress-Null-Values-in-Expression/m-p/951861#M958775 Kushal_Chawda 2015-11-06T14:14:26Z