Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

paulyeo11
Not applicable

Payment report how to remove those row with null value ?

Hi All

My payment table only 7 row have data , and balance 100 row with null value.

In order to remove null row , i need to use Below expression is working fine :-


if((Sum(curren)+Sum(days3)+Sum(days6)+Sum(days9)+Sum(above12))<>0, COMPANY_PAY, '')

it should remove those row when curren field value = 0

But it does not work.

Can some one advise me ?

Remark in QV it work fine but now in QS.

Paul

1 Reply
paulyeo11
Not applicable

Re: Payment report how to remove those row with null value ?

my qvf