topic Empty row removal in QlikView

Empty row removal

dhanavindhan — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Empty row removal

dapostolopoylos — Fri, 23 Nov 2018 13:49:19 GMT

Try this

Re: Empty row removal

dhanavindhan — Mon, 26 Nov 2018 04:49:57 GMT

No, not working still empty row coming.

Re: Empty row removal

Frank_Hartmann — Mon, 26 Nov 2018 08:25:10 GMT

what happens if you use the following expression?

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