topic Expression for current year total days in QlikView

Expression for current year total days

Anonymous — Thu, 31 Jul 2014 06:09:19 GMT

Hi Qlikers,

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

Please suggest me the best expression .

aveeeeeee7en — Thu, 31 Jul 2014 06:14:59 GMT

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 — Thu, 31 Jul 2014 06:33:47 GMT

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

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

Thu, 31 Jul 2014 06:40:15 GMT

Hi,

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

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

Regards,

Vivek