topic Re: How can I get rid of this blank spaces in my report in QlikView

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

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

I have also attached my qvw for reference

Anonymous — Tue, 11 Sep 2018 08:07:25 GMT

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 — Tue, 11 Sep 2018 08:09:34 GMT

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