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.