Empty row removal

[dhanavindhan]

Dear People,

I have a pivot table in my qlikview which bring some empty row with $0 in my table when i made any selection from my filters. When showing all records that empty row is not coming. I don't know how to avoid this from table.

Is there any solution to sort out this issue.

Screenshot attached below FYR,

Note: I need all vesselname in my header without fail. Even though I choose any selections it should show all vessel name header. So, I enabled vesselname dimension "Show all values". If value is not there it should left blank without any values as u see now in report. I am attaching my qvw with this thread.

Reg,

Dhana R

[dapostolopoylos]

Try this

[dhanavindhan]

No, not working still empty row coming.

[Frank_Hartmann]

what happens if you use the following expression?

sum( IBSReport.onhirerate)*avg({1}1/1)