Mass Data Import Into QPR Metrics

3 posts 0 new
Log in or register to post comments.

Mass Data Import Into QPR Metrics

I am trying to perform a mass data import from an excel file. I have all the required column headings, infact I am able to import data for a monthly period but cannot do the import for a weekly period. I have tried using the exact name of the weekly period, for example "$W1/2015" in the date column of my excel file but I am getting an error stating the period cannot be found. I have also tried using the weekly date format created in the QPR periods for example, 2/02/2015 (dd/mm/yyyy) and (mm/dd/yyyy) but to no avail. Any help is greatly appreciated


Hi techguy!

Have you been able to create weekly periods correctly to Metrics?

If yes, is the syntax correct for the weekly period "W1 / 2015" vs. "W1/2015" in Excel.

Please let me know if you require further assistance.






Thanks much for the reply Janne Warpenius, I did tried your suggested format also but it did not work. However, what work for me was leaving out the two double quotation marks and using one single quotation mark to the left of the period format. like 'W1 / 2015.