topic Re: How to write expression to get values in QlikView https://community.qlik.com/t5/QlikView/How-to-write-expression-to-get-values/m-p/549832#M1132059 <HTML><HEAD></HEAD><BODY><P>Thanks for your answer.</P></BODY></HTML> Wed, 20 Nov 2013 12:05:29 GMT 2013-11-20T12:05:29Z How to write expression to get values https://community.qlik.com/t5/QlikView/How-to-write-expression-to-get-values/m-p/549825#M1132052 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>I have to use Sum(Commision) in staright table but oit contains some NULL values</P><P></P><P>how to write expression to skip null values i,e to replace NULL with zero.</P><P></P><P>Thanks.</P></BODY></HTML> Wed, 20 Nov 2013 11:07:04 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression-to-get-values/m-p/549825#M1132052 2013-11-20T11:07:04Z Re: How to write expression to get values https://community.qlik.com/t5/QlikView/How-to-write-expression-to-get-values/m-p/549826#M1132053 <HTML><HEAD></HEAD><BODY><P>You mean field Commission contain NULLs?</P><P></P><P>I think what you want is the default behaviour of sum(), what do you observe?</P></BODY></HTML> Wed, 20 Nov 2013 11:09:30 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression-to-get-values/m-p/549826#M1132053 swuehl 2013-11-20T11:09:30Z Re: How to write expression to get values https://community.qlik.com/t5/QlikView/How-to-write-expression-to-get-values/m-p/549827#M1132054 <HTML><HEAD></HEAD><BODY><P>Yes filed commision has Null values</P><P></P><P>so, I need to use ISNULL function . can you please send me the expression how to use ISNULL</P></BODY></HTML> Wed, 20 Nov 2013 11:10:37 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression-to-get-values/m-p/549827#M1132054 2013-11-20T11:10:37Z Re: How to write expression to get values https://community.qlik.com/t5/QlikView/How-to-write-expression-to-get-values/m-p/549828#M1132055 <HTML><HEAD></HEAD><BODY><P>Well, if I understood correctly, sum(Commission) should be enough, summing all numeric values (and NULL is not a value).</P><P></P><P>You probably ask for something like</P><P></P><P>=sum(if (not isnull(Commission), Commission,0))</P><P></P><P>but I don't think that returns something different than just sum(Commission).</P></BODY></HTML> Wed, 20 Nov 2013 11:18:30 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression-to-get-values/m-p/549828#M1132055 swuehl 2013-11-20T11:18:30Z Re: How to write expression to get values https://community.qlik.com/t5/QlikView/How-to-write-expression-to-get-values/m-p/549829#M1132056 <HTML><HEAD></HEAD><BODY><P>Well you could also 'fix' your Nulls in the load script in a similar manner and thereby avoid worrying about it at the expression stage. Thus you could write something along the lines of:</P><P></P><P>Assuming your load script looks similar to this now:</P><P></P><P>LOAD</P><P>Commission</P><P>FROM ...</P><P></P><P>You could try doing this instead:</P><P></P><P>LOAD </P><P>If(IsNull(Commission,0,Commission) as Commission</P><P>FROM ...</P><P></P><P>// the logic of the above is if the value of Commission field = Null then let its value be 0, otherwise just use whatever value Commission field already has.</P></BODY></HTML> Wed, 20 Nov 2013 11:26:25 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression-to-get-values/m-p/549829#M1132056 2013-11-20T11:26:25Z Re: How to write expression to get values https://community.qlik.com/t5/QlikView/How-to-write-expression-to-get-values/m-p/549830#M1132057 <HTML><HEAD></HEAD><BODY><P>Thanks and I suppose I should have use</P><P></P><P>sum(if ( isnull(Commision),0, Commision))</P></BODY></HTML> Wed, 20 Nov 2013 11:41:53 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression-to-get-values/m-p/549830#M1132057 2013-11-20T11:41:53Z Re: How to write expression to get values https://community.qlik.com/t5/QlikView/How-to-write-expression-to-get-values/m-p/549831#M1132058 <HTML><HEAD></HEAD><BODY><P>Well IMO both swuehl and your logic will work, one is just the reverse logic of the other.</P></BODY></HTML> Wed, 20 Nov 2013 12:01:33 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression-to-get-values/m-p/549831#M1132058 2013-11-20T12:01:33Z Re: How to write expression to get values https://community.qlik.com/t5/QlikView/How-to-write-expression-to-get-values/m-p/549832#M1132059 <HTML><HEAD></HEAD><BODY><P>Thanks for your answer.</P></BODY></HTML> Wed, 20 Nov 2013 12:05:29 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression-to-get-values/m-p/549832#M1132059 2013-11-20T12:05:29Z Re: How to write expression to get values https://community.qlik.com/t5/QlikView/How-to-write-expression-to-get-values/m-p/549833#M1132060 <HTML><HEAD></HEAD><BODY><P>in presentation tab below null symbol puts - replace it with 0 then ok</P><P>hope it helps</P></BODY></HTML> Wed, 20 Nov 2013 12:20:31 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression-to-get-values/m-p/549833#M1132060 er_mohit 2013-11-20T12:20:31Z