Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikers,
I want to know total days in a current year days..
Please suggest me the best expression .
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
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
interval(YearEnd(Today())-YearStart(Today()),'DD')
or
age(YearEnd(Today()),YearStart(Today()))
Hi,
to get the number of days in current Year use this expression
=floor(Num(YearEnd(Today()))-Num(YearStart(Today()))) + 1
Regards,
Vivek