Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Using Class function we can achieve this.

Sample is attached

View solution in original post

2 Replies
Anonymous
Not applicable
Author

Any help??

Anonymous
Not applicable
Author

Using Class function we can achieve this.

Sample is attached