Delete Spaces

[pgalvezt]

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

[m_woolf]

Try using this as your dimension:

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

[swuehl]

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.]);

[#4]

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.

[#5]

Use

Where Isnum([Nº doc.])

in your load

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