topic Re: Reading from excel in QlikView

Reading from excel

Thu, 20 Nov 2014 10:17:49 GMT

Hi All,

Need to develop a application were user will view the current project status based on color (green/amber/red) from the excel file attached. I need a script were qv will read the - 1. Project Status (from report sheet) 2. Key Mile Stones 3) Emp name (from timesheet)

4) all other fields from the Timesheet ...

Kindly advice how to proceed.....

link to the excel file - IBM.xlsx

there will be multiple excel files on week/monthly wise and qv needs to read periodically........................

Re: Reading from excel

simondachstr — Thu, 20 Nov 2014 10:24:44 GMT

Go to the script - at the very bottom you have a tab called Data -> Data from Files. Select Table files and pick your IBM.xlsx file. There you should be able to see your fields you wish to read. Everything else from there on should be straightforward.

If you wish to read multiple excel files I recommend creating a standard xls-file name e.g. TimeSheet_Owner_Date.xlsx and then load all files at once using the * qualifier e.g.

TimeSheet_*.xlsx

This will read all available xlsx files with the same beginning filenames.