Creating detail from high-level data in QV data load

burgersurfer — Thu, 05 Aug 2010 15:05:53 GMT

I have a set of numbers summarised by month, that must be loaded into QV as daily data. Something like this:

Store Year Month Sales Budget

1 2000 1 1000 1200

1 2000 2 2100 2100

.... (up to month 12, year 2005)

2 2001 1 500 600

2 2001 2 600 800

..... (up to month 12 and year 2010)

....

I have a data structure set up to deal with daily data and need to get the budget and sales information broken into daily values (e.g. sales for month1 / 31 days, for month 2 divided by 28 days etc).

Is there a way to program something like this into the QV data load? e.g.

Load...

Store as Store_No

Month

Sales/{Days this month represents} as DailySales

....

Thanks!

topic Creating detail from high-level data in QV data load in QlikView

Creating detail from high-level data in QV data load