reference specific cells in excel

[#1]

Hi All,

I am very new to qlikview but am loving what can be done with the product. I trying to create a proof of concept to present, I am try to turn the data that gets provided daily in an excels into a dashboard.

LOAD

date(date# (mid(filename(), 14, 6), 'DDMMYY'), 'DD MMMM YY') as OrderDate,

date(date# (mid(filename(), 16, 2), 'DDMMYY'), 'MMMM') as MonthDate,

Client,

[Incident Count],

[Primary Uptime],

[Primary Uptime %],

[Secondary Uptime],

[Secondary Uptime %],

[Total Uptime],

[Toatal Uptime %]

FROM

(biff, embedded labels, table is FrontPage$, filters(

Remove(Row, Pos(Top, 153)),

Remove(Row, Pos(Top, 152)),

and this goes on for a while deleting rows.

then pull the data from: -

A180:H187

Row 180 is used as the Embedded Labels.

But i have found that some of the spreadsheets are not identical, there are extra blank rows, which when pulled into are deleted out which moves the positioning of the data needed.

Is there a way of the blank rows not been deleted? Or to select the same reference point in the excel sheets?

Cheers,

[#2]

Hi Rocky,

Just wondering if you had found any other possible option.

Cheers,

Joe

[boorgura]

Sorry Joe,

dint really find time to work on it.

Will keep you posted if I figure out something.

[prieper]

Within the concept to scan for certain keywords in an Excel, you may have a look into

http://community.qlik.com/forums/t/36505.aspx

Model is pretty simple and might be brushed up a bit for your purpose, but works.

HTH
Peter

[#5]

Thanks for your help guys. I was able to access the raw data. Which meant i could do the calculations on the import and generate the information that i needed.

Raw data is much better!!!!!