topic Re: current year and month in QlikView

current year and month

Tue, 15 Apr 2014 09:12:53 GMT

Hi Community,

i want to show current year and current month by opening a document with out using MAX function

Tue, 15 Apr 2014 09:17:31 GMT

You can Take a text box and write below expression in it to display current year and month:

For Current year:

=Year(Today())

For Current Month:

=Month(Today())

I hope this is what you want..!

ThornOfCrowns — Tue, 15 Apr 2014 09:18:22 GMT

You can get the current year and month by using Year(Now()) and Month(Now())

amit_saini — Tue, 15 Apr 2014 09:30:03 GMT

Hi Kannuri,

In a Text box use this:

='[ Updated at ' & timestamp(reloadtime(), 'hh:mm on MMM DD, YYYY') &' ]'

Thanks,

MK_QSL — Tue, 15 Apr 2014 09:31:26 GMT

Year(Today())

Month(Today())

its_anandrjs — Tue, 15 Apr 2014 09:34:58 GMT

You can Write below in any text box or in variables

For Year >> =Year( Now( ) )

For Month >> =Month( Now( ) )

And also you use

=Year(Today( ) )

=Month(Today( ) )