adding historical sales data to my qlikview

[chriscools]

Hello,

recently we changed from  ERP system,  and  decision was made not to upoad historical data in  the new system.

now i'm making an analysis on store sales, and i would like to compare this month to the same month last year.

i have excelfiles which can give me total sales amount per day per store.

i don't have more detailed info (articles, qty,..) but for comparison i don't need that kind of detail.

can i do it like this:

i make 1 excel file with the following columns:

-shopname

-date

-salesamount for that day (which i probably need to label as "LineSalesAmount" to have it also calculated in the expression?)

then i past all files from last year into  this one file, include it in the data load with the right fieldnames so that data gets in the right fields after upload.

will it work like this, or is there more to it?

thanx!

chris

[Gysbert_Wassenaar]

Basically yes, that's pretty much it. If you discover that you will have to deal with data at different levels of granularity check out this article by Henric Cronström

[chriscools]

Hello,

i tried it, but it gives me a warning that several loops are found...

could you perhaps have a look at what i'm doing wrong?

in include the qlikview document and the excel file.

grtz,

chris

[Gysbert_Wassenaar]

try:

concatenate(Sales) load

Date&Shop as %id_sale,

Shop as %id_shop,

Date

FROM

(ooxml, embedded labels, table is Blad1);

concatenate(Fact) load

Date&Shop as %id_sale,

Linesalesamount

FROM

(ooxml, embedded labels, table is Blad1);

Or maybe you want Shop&Date as %id_sale instead of Date&Shop as %id_sale or maybe something else using for example autonumber.

[chriscools]

Hello,

where should i put that ?under  the load statement?

or does this replace the previous load statement for the excel file?

grtz,

chris

[Gysbert_Wassenaar]

Yes, replace the previous load statement for the excel file.