topic Re: Date in QlikView

Date

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

I want to creat a variable which should show current month today

how can i do this ?

Re: Date

Anil_Babu_Samineni — Fri, 09 Jun 2017 06:58:06 GMT

Is that Current month in selection? Perhaps this

LET Variable1 = Today();

Re: Date

devarasu07 — Fri, 09 Jun 2017 07:00:43 GMT

Hi,

You can create variable like below,

vMaxMonth

=max(Month(Today())) // this will return latest year month no

=MonthName(addmonths(today(),1)) // this will return latest year with month name

and also you can write the expression in chart like below

=$(=max(month(Today())))

Hope this helps you

Regards,

Deva

Re: Date

smilingjohn — Fri, 09 Jun 2017 07:04:55 GMT

Hi Anil

NO we are not making any month selctions ,

i have month as a field in the script which has moths in that ,

So i want to have to vairable whch should shouw current month

thanks

Re: Date

prma7799 — Fri, 09 Jun 2017 07:06:14 GMT

You can create variable in variable expression or using LET

vCurrMonth=month(Today());

Re: Date

qlikcheepirishe — Fri, 09 Jun 2017 07:07:50 GMT

=Month(Today()) will display Jun

just do Ctrl+Alt+V then click on add

name write vMonth in definition =Month(Today())

Re: Date

Fri, 09 Jun 2017 07:10:32 GMT

Hi there,

You can also do this by

LET vMonthYear =monthname(Today())

it will give you 'Jun 2017'

Thank You.

Re: Date

smilingjohn — Fri, 09 Jun 2017 07:18:18 GMT

Thanks for the reply mahesh ,

How can we cover the month field which has text as jun,jul,august ....son into month number ?

I want to display the current month into number

Thats is 6 for jun ?

Re: Date

qlikcheepirishe — Fri, 09 Jun 2017 07:28:05 GMT

=num(month(now()))

it will display month to num for example June the above definition will display '6'

Re: Date

prma7799 — Fri, 09 Jun 2017 07:35:40 GMT

=num(month(Today()))

Re: Date

kamal_sanguri — Fri, 09 Jun 2017 07:38:57 GMT

Num(Month(Date#('Jan','MMM')))

you may replace 'Jan' with your month field.