Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
trishita
Creator III
Creator III

How can I get rid of this blank spaces in my report

I have also attached my qvw for reference

1 Solution

Accepted Solutions
Anonymous
Not applicable

do you want to get rid of the complete row if column Difference Log contains spaces?

like this?

Then you Need to assign null values for this column:

if (len([Difference Log vs Survey])=0,null(),[Difference Log vs Survey])

in the other colums like flag you also Need to assign null if the column Difference Log is null like

if (len([Difference Log vs Survey])=0,null(),
  
if (isnull(SOUNDING_START_DATE),1,0))

fürthermore you need  to suppress Zero values for all dimensions

Sorry, I cannot upload your qvw!

View solution in original post

2 Replies
Anonymous
Not applicable

do you want to get rid of the complete row if column Difference Log contains spaces?

like this?

Then you Need to assign null values for this column:

if (len([Difference Log vs Survey])=0,null(),[Difference Log vs Survey])

in the other colums like flag you also Need to assign null if the column Difference Log is null like

if (len([Difference Log vs Survey])=0,null(),
  
if (isnull(SOUNDING_START_DATE),1,0))

fürthermore you need  to suppress Zero values for all dimensions

Sorry, I cannot upload your qvw!

trishita
Creator III
Creator III
Author

Yes I want to delete the records which have no value for olumn Difference Log..Ok let me check what you have done