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: 
rahulsingh12
Contributor III
Contributor III

Distributing Days across Months

Hi,

I have two dates

start date: 01/05/2017    

EndDate: 03/06/2017

I want to distribute the number of days between the days to the months.

start date: 01/05/2017     jan   feb   mar   apr  may  jun   jul  aug sep oct   nov   dec

EndDate: 03/06/2017        0      0     0       0      31    3      0     0    0    0      0       0

How can I achieve this?

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

See new Attachment.

View solution in original post

25 Replies
sunny_talwar

You want this in the script or front end?

rahulsingh12
Contributor III
Contributor III
Author

In front end if possible.

Once the data is matches then might move it to the script level.

Regards,

Rahul

rahulsingh12
Contributor III
Contributor III
Author

I wanted it in front end.

Regards,

rahulsingh12
Contributor III
Contributor III
Author

yes

Regards,

sunny_talwar

Would you be able to share a sample to show your data model so that I can propose the best possible way to do this?

rahulsingh12
Contributor III
Contributor III
Author

Hi i wont be able to share the sample data as i am on  a client visit.

Consider the above two as my data with only change that the months across which the days is to be distributed is coming from the two dates only.

Regards,

antoniotiman
Master III
Master III

Hi Raul,

StartDate = 10/04/2017

EndDate = 03/06/2017

See Attachment.

Regards,

Antonio

rahulsingh12
Contributor III
Contributor III
Author

can you share the code you have written as i don't see any attachment.

regards,

rahulsingh12
Contributor III
Contributor III
Author

got it.

thanks