Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
proctors
Creator
Creator

Transform or Specify Excel File Cell Import Structure

Hi. We have a huge data set of excel files that a colleague used to chart patient's behavior from week to week. He uses the same excel sheet format from week to week and we want to be able to import it into Qlikview. However, his format does not follow the typical row-by-row that we all know is best for importing data. Is there a way for met to tell Qlikview where certain information is per sheet? For example, Name is at B1, Date is at B2, MAM Goal is at C3, and so on.  Screenshot of it is below.

1 Reply
krishna_2644
Specialist III
Specialist III

Hi - to convert the format(kind of pivot table) that you have in excel, you need to be able to write some script to convert into qlikview readable table data.

please post your excel with smple data and your desired output.we can play around with it.