Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New 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
Honored Contributor 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?

Highlighted
New 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
New Contributor III

Re: Distributing Days across Months

I wanted it in front end.

Regards,

Highlighted
New 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
New 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
Honored Contributor III

Re: Distributing Days across Months

Hi Raul,

StartDate = 10/04/2017

EndDate = 03/06/2017

See Attachment.

Regards,

Antonio

Highlighted
New Contributor III

Re: Distributing Days across Months

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

regards,

Highlighted
New Contributor III

Re: Distributing Days across Months

got it.

thanks