Expression for current year total days

[Anonymous]

Hi Qlikers,

I want to know total days in a current year days..

Please suggest me  the best expression .

[aveeeeeee7en · Accepted solution]

Try something like this in Text Box Expression:

1)  round(YearEnd(Today())-YearStart(Today()))

2)  round(YearEnd(vMaxYear)-YearStart(Today(vMaxYear))) 

Create vMaxYear Variable and give value in it like vMaxYear=Year(Today) or vMaxYear=Max(Year)

Hope that helps you.

Regards

Aviral Nag

[SunilChauhan]

interval(YearEnd(Today())-YearStart(Today()),'DD')

or

age(YearEnd(Today()),YearStart(Today()))

[#4]

Hi,

to get the number of days in current Year use this expression

=floor(Num(YearEnd(Today()))-Num(YearStart(Today()))) + 1

Regards,

Vivek