Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.