topic Re: Delete Spaces in QlikView

Delete Spaces

pgalvezt — Fri, 17 Feb 2012 16:55:18 GMT

Hi, I have some problems with my forms. I need to know delete the first and the second row in QlikView. I need to start for 100147483. Left an example.

Thanks

Delete Spaces

m_woolf — Fri, 17 Feb 2012 17:08:56 GMT

Try using this as your dimension:

=if(num([Nº doc.])>0,[Nº doc.])

Delete Spaces

swuehl — Fri, 17 Feb 2012 17:11:51 GMT

And it's probably a good idea to remove the lines in your load, I think they are not needed, just line headers in Excel, right?

LOAD...

from Table.xls where isnum([Nº doc.]);

Delete Spaces

Fri, 17 Feb 2012 17:12:25 GMT

when you select the xl to get data from, there's one Header Size which defaults to None. It has a drop down, select Lines and enter 2 (in your case) in the small box to the right. Then in Labels, drop down and select Embedded. this should get rid of the 2 lines you wish to get rid of.

Re: Delete Spaces

Fri, 17 Feb 2012 17:33:33 GMT

Use

Where Isnum([Nº doc.])

in your load

edit: swuehl beat me to it. should've refreshed topic beefore posting.