Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

QS straight table how to null zero value ?

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

9 Replies
Not applicable

Re: QS straight table how to null zero value ?

try using expression :

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

paulyeo11
Valued Contributor II

Re: QS straight table how to null zero value ?

! !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

paulyeo11
Valued Contributor II

Re: QS straight table how to null zero value ?

Hi All

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

Paul

Not applicable

Re: QS straight table how to null zero value ?

Hi u can use conditional dimension

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

uncheck show null values

expression :  Sum(above12)

paulyeo11
Valued Contributor II

Re: QS straight table how to null zero value ?

Hi Sir

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

row with missing value.png

Not applicable

Re: QS straight table how to null zero value ?

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

paulyeo11
Valued Contributor II

Re: QS straight table how to null zero value ?

Enclosed my QVF doc

Not applicable

Re: QS straight table how to null zero value ?

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

paulyeo11
Valued Contributor II

Re: QS straight table how to null zero value ?

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


Community Browser