topic Re: Calculating the Number days between a specified range in QlikView

Calculating the Number days between a specified range

Thu, 04 Dec 2014 04:21:20 GMT

Hi,

I have a requirement wherein I need to obtain the number of days that fall between the start date of the Fiscal Year till the max of month which is selected.

For eg.if May and Jun is selected and year 2013 is selected I need to obtain the nimber of days between the start of Fiscal year to end of Jun which is 91(Apr1-Jun-30) similarly suppose if Month April is selected I must get 30 as the no of days.Please let me know how this could be done.

Re: Calculating the Number days between a specified range

sushil353 — Thu, 04 Dec 2014 07:36:46 GMT

Hi,

It s better to have a fiscal calendar for this situation.

check out this: http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year

HTH

Sushil

Re: Calculating the Number days between a specified range

Anonymous — Thu, 04 Dec 2014 09:46:56 GMT

Hi Anushree

use input boxes and convert this values into yyyy-mm-dd hh:mm and the use the below formula

Try this DayStart('1990-10-30 9:20')-DayStart('1990-09-18 9:20')

or post sample application i can help you

Regards

Harsha