Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

leni_balakrishn
Contributor III

Split set of Dates based on the input value

Hi,

My scenario is

In my table I have two fields Date and Amount.

I need to split the set of dates based on the given input.

Like,

If I gave input as 10, then it should split dates in 10. From 01-09-2012 to 10-09-2012, 11 to 20 and so on and the sum of amount to be calculated for the date frame.

For Example,

Date                               Amount

01-09-2012                          10

02-09-2012                          10   

03-09-2012                          10

04-09-2012                          20

05-09-2012                          20   

06-09-2012                          20

Input value = 3

output:

DateFrame                            Amount

01-09-2012 - 03-09-2012          30

04-09-2012 - 06-09-2012          60

Thanks in Advance.

Regards,

Leni

Tags (1)
1 Solution

Accepted Solutions
leni_balakrishn
Contributor III

Re: Split set of Dates based on the input value

Using Class function we can achieve this.

Sample is attached

2 Replies
leni_balakrishn
Contributor III

Re: Split set of Dates based on the input value

Any help??

leni_balakrishn
Contributor III

Re: Split set of Dates based on the input value

Using Class function we can achieve this.

Sample is attached

Community Browser