topic Re: QS straight table how to null zero value ? in App Development

QS straight table how to null zero value ?

paulyeo11 — Thu, 04 Jun 2015 21:29:55 GMT

Hi All

I have create a payment report like below in QS :-

CUST_ID COMPANY CURRENT 30 DAY 60 DAY 90 DAY 120 DAY.

I try to set all field turn on null missing value. Yet it still display those row all value are zero.

As my report hv 100 row. Only 6 row have value. I only want to display those 6 row.

Any work around ?

Paul

Re: QS straight table how to null zero value ?

Sun, 07 Jun 2015 10:59:01 GMT

try using expression :

if(sum(payment) <> 0, sum(payment), null())

Re: QS straight table how to null zero value ?

paulyeo11 — Mon, 08 Jun 2015 12:33:42 GMT

! !Hi Sir

I have try your propose script , but still not able to remove those row with zero.

Enclosed is my QV doc and QVF doc , hope you can advise me.

Paul

Re: QS straight table how to null zero value ?

paulyeo11 — Mon, 08 Jun 2015 12:36:28 GMT

Hi All

My QV Doc , which able to null row with zero value.

Paul

Re: QS straight table how to null zero value ?

Tue, 09 Jun 2015 11:41:07 GMT

Hi u can use conditional dimension

Dimension : if(aggr(Sum(above12),cust_id) > 0, cust_id)

uncheck show null values

expression : Sum(above12)

Re: QS straight table how to null zero value ?

paulyeo11 — Sun, 14 Jun 2015 16:42:04 GMT

Hi Sir

I try to use the diamension expression , you suggest to me , but it still not able to work.

Re: QS straight table how to null zero value ?

Mon, 15 Jun 2015 04:49:58 GMT

Can you send me QVF file with sample data....

Re: QS straight table how to null zero value ?

paulyeo11 — Mon, 15 Jun 2015 14:26:31 GMT

Enclosed my QVF doc

Re: QS straight table how to null zero value ?

Tue, 16 Jun 2015 05:09:17 GMT

have a look at this qvf file. hope this helps !

Re: QS straight table how to null zero value ?

paulyeo11 — Wed, 17 Jun 2015 11:14:53 GMT

Hi Sir

I just test with your qvf file , it work fine.

if(aggr(Sum(above12),cust_id) > 0, cust_id)

now my issue is how to modify the the above expression to check for other field name :-

above12

days9

days6

days3

curren

To null when all above field are zero and not display the row.

any advise ?

Paul