Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Master III
Master III

Re: Distributing Days across Months

See new Attachment.

View solution in original post

25 Replies
Highlighted

Re: Distributing Days across Months

You want this in the script or front end?

Contributor III
Contributor III

Re: Distributing Days across Months

In front end if possible.

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

Regards,

Rahul

Highlighted
Contributor III
Contributor III

Re: Distributing Days across Months

I wanted it in front end.

Regards,

Highlighted
Contributor III
Contributor III

Re: Distributing Days across Months

yes

Regards,

Highlighted

Re: Distributing Days across Months

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?

Highlighted
Contributor III
Contributor III

Re: Distributing Days across Months

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,

Highlighted
Master III
Master III

Re: Distributing Days across Months

Hi Raul,

StartDate = 10/04/2017

EndDate = 03/06/2017

See Attachment.

Regards,

Antonio

Highlighted
Contributor III
Contributor III

Re: Distributing Days across Months

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

regards,

Highlighted
Contributor III
Contributor III

Re: Distributing Days across Months

got it.

thanks