topic Script expression for current month in QlikView

Script expression for current month

Mon, 14 Dec 2009 17:47:37 GMT

Please,

How do I wirte in the edit script, an expression for the current month. So that I can create a button object for a selection of current month only.

Please maximum help is needed

Dan

Script expression for current month

Miguel_Angel_Baeyens — Mon, 14 Dec 2009 17:57:01 GMT

Hello Dan,

You can always use something like:

Num(Month(Today()))

To get the current month number.

Script expression for current month

Mon, 14 Dec 2009 18:04:47 GMT

Thanks Miguel,

Then how do I create a button object to select only the current month. Your help is appreciated

Script expression for current month

Miguel_Angel_Baeyens — Mon, 14 Dec 2009 18:21:12 GMT

If you are using version 9, just create a new button object, go to actions -> add -> "Type" = selection and on the right list, select "Select in field". You will be asked for the field name you want to search and the Search String, which is

=Num(Month(Today()))

(note the "=" before the expression).

And that's it!

Script expression for current month

Mon, 14 Dec 2009 18:34:28 GMT

Sorry I'm disturbing you so much. What do I type in the "Field" in the "Actions" tab of the button properties?

Also, is there any need for anything in the enable conditions?

AW:Re: Script expression for current month

Mon, 14 Dec 2009 19:12:17 GMT

Hi,

if you want you can try it with an other idea.

1. Load an additional Field with


Load
...
inmonth(<DateField>,Now()) as ActualMonth
...
FROM...

2a. Create the Button, and as Action select "Select in Field"

2b. as Field select "ActualMonth" or whatever you have named that field

2c. as Search String take "1" (without the quotes)

Then it should select only the values in the actual month.

Have fun with QlikView

Alex:)

Script expression for current month

Mon, 14 Dec 2009 19:13:10 GMT

my suggestion is :

RUN MACRO it will solve all problems.

In macro is where u will use vbscript coding.

Hope u will b fine.

Script expression for current month

Miguel_Angel_Baeyens — Mon, 14 Dec 2009 19:19:47 GMT


dan wrote:Sorry I'm disturbing you so much. What do I type in the "Field" in the "Actions" tab of the button properties?

Your Month Name Field or Date Name Field.


dan wrote:Also, is there any need for anything in the enable conditions?

As far as I understand you just want to make a button to make selection equal to current month. So no, it doesn't. Well, depending on your chart, but that would be a different question.

AW:Re: Script expression for current month

Mon, 14 Dec 2009 19:24:10 GMT

Hi I tried the inmonth thing, but it says, Error: inmonth takes 3-4 parameters.

what do i do?

AW:Re: AW:Re: Script expression for current month

Mon, 14 Dec 2009 19:45:52 GMT

Sorry it was

inmonth(<Datefield>,now(),0) (see help for more information)

Alex:)

AW:Re: Script expression for current month

Tue, 15 Dec 2009 02:55:16 GMT

Dan,

See the attached QVW file for reference. The "CurrentMonth" field is loaded as part of the script (thanks to Alex for the code).

Please let us know if this answers your quesiton.

AW:Re: Script expression for current month

Thu, 17 Dec 2009 17:51:48 GMT

Yes it works, thanks guys...