Split data by 7 days interval

ipauldur — Mon, 24 Jun 2013 02:05:39 GMT

Hi All,

I have sum of amount by date. I want to show this amount in 7 days interval in pivot table. The starting date and number of 7 days(Weekly) will be input(Input box).

The starting date may be any weekday name sun, mon,tue and etc..

There is two inputs. 1. Start Date and 2. Number of weeks (Numeric).

If start date is monday(10/Jun/2013) and Number of weeks = 2, then my result should be,

Asset	Week	Amount
Total		10,424,379.90
AB	10/06/2013 (Mon) - 16/06/2013 (Sun)	5,250,139.17
CD	17/06/2013 (Mon) - 23/06/2013 (Sun)	5,174,240.73

If start date is Wednesday(12/Jun/2013) and Number of weeks = 2, then my result should be,

Asset	Week	Amount
Total		10,424,379.90
AB	12/06/2013 (Wed) - 18/06/2013 (Tue)	5,250,139.17
CD	19/06/2013 (Wed) - 25/06/2013 (Tue)	5,174,240.73

The number of weeks input is upto 54. Is this possible? Please let me know.

Thanks in advance,

Durai.

Re: Split data by 7 days interval

ipauldur — Mon, 24 Jun 2013 08:22:13 GMT

Hi All,

I have done using Class function.

Thanks

topic Split data by 7 days interval in QlikView

Split data by 7 days interval

Re: Split data by 7 days interval