topic Re: Date to endquarter function? in QlikView

Date to endquarter function?

Thu, 26 Feb 2015 18:22:55 GMT

I have to calculate the days from today()-1 to the end of the cuarter.

There is any function similar to InQuarterToDate?

Thank you

Greetings

maxgro — Thu, 26 Feb 2015 18:46:59 GMT

date between today()-1 and end quarter

tmp:

load

date(makedate(2015) -1 + rowno()) as date

autogenerate 366;

Right keep (tmp)

load

date

Resident tmp

where date > (today()-1) and InQuarter(date, today(), 0);

Thu, 26 Feb 2015 18:47:52 GMT

Thank you, finally i did this to count the number of days

round(QuarterEnd(today()) - today () ) -1)

Anonymous — Thu, 26 Feb 2015 18:48:24 GMT

This should work:

QuarterEnd(today()) - (today()-1)

Thu, 26 Feb 2015 18:49:23 GMT

Yeah i've done that

Thank you for your help

Greetings