This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Hi All ,
I want to creat a variable which should show current month today
how can i do this ?
it will display month to num for example June the above definition will display '6'
View solution in original post
Is that Current month in selection? Perhaps this
LET Variable1 = Today();
You can create variable like below,
=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
Hope this helps you
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
You can create variable in variable expression or using LET
=Month(Today()) will display Jun
just do Ctrl+Alt+V then click on add
name write vMonth in definition =Month(Today())
You can also do this by
LET vMonthYear =monthname(Today())
it will give you 'Jun 2017'
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 ?