topic Not return 0 values in QlikView

Not return 0 values

jenmclean — Fri, 30 May 2014 19:56:35 GMT

How would I write this expression so that it will only show values that are greater than 0?

(Sum({$<PARTS|SubTypeDesc-={'NATIONAL ACCOUNTS PART', 'NATIONAL ACCOUNTS BATTERY', 'NET STATE'}, PARTS|ActiveFlag={1}>}PARTS|OnHandInv)=0, Null(), (PARTS|OnHandInv-PARTS|Obligated-PARTS|KeepOnHand))

Re: Not return 0 values

eduardo_sommer — Fri, 30 May 2014 19:59:20 GMT

Try

if((Sum({$<PARTS|SubTypeDesc-={'NATIONAL ACCOUNTS PART', 'NATIONAL ACCOUNTS BATTERY', 'NET STATE'}, PARTS|ActiveFlag={1}>}PARTS|OnHandInv)=0, Null(), (PARTS|OnHandInv-PARTS|Obligated-PARTS|KeepOnHand))> 0,

(Sum({$<PARTS|SubTypeDesc-={'NATIONAL ACCOUNTS PART', 'NATIONAL ACCOUNTS BATTERY', 'NET STATE'}, PARTS|ActiveFlag={1}>}PARTS|OnHandInv)=0, Null(), (PARTS|OnHandInv-PARTS|Obligated-PARTS|KeepOnHand)))

if the result is 0 or less, the expression will return a null value

Eduardo

Re: Not return 0 values

preminqlik — Fri, 30 May 2014 20:13:57 GMT

hi there try this

(Sum({$<PARTS|SubTypeDesc-={'NATIONAL ACCOUNTS PART', 'NATIONAL ACCOUNTS BATTERY', 'NET STATE'}*{'=(Sum({$<PARTS|SubTypeDesc-={'NATIONAL ACCOUNTS PART', 'NATIONAL ACCOUNTS BATTERY', 'NET STATE'}, PARTS|ActiveFlag={1}>}PARTS|OnHandInv)=0, Null(), (PARTS|OnHandInv-PARTS|Obligated-PARTS|KeepOnHand))>0'}, PARTS|ActiveFlag={1}>}PARTS|OnHandInv)=0, Null(), (PARTS|OnHandInv-PARTS|Obligated-PARTS|KeepOnHand))

Re: Not return 0 values

jenmclean — Fri, 30 May 2014 21:17:41 GMT

Clarifiying, I need it to only display results that are postive or negative and NOT 0.

Re: Not return 0 values

eduardo_sommer — Fri, 30 May 2014 21:46:13 GMT

Just change the >0 to <>0 in my earlier suggestion (in the end of second line)

Eduardo