Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
dhanavindhan
Creator
Creator

Empty row removal

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,with empty.jpgwithout empty.png

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

 

 

3 Replies
dapostolopoylos
Creator III
Creator III

Try this

Capture.JPG

Father/Husband/BI Developer
dhanavindhan
Creator
Creator
Author

No, not working still empty row coming.

 

Frank_Hartmann
Master II
Master II

what happens if you use the following expression?

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