# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Rules, plus terms and conditions, can be found here.
New Contributor II

## set analysis

Hi,

I am using the function -

sum( {\$<MonthName = {May}, system= {Y,X}>} [QUANT] )/1000

But what I realy want is the month not to be May, but to be the current month.

How should I checged the syntex of the function?

Thanks!

1 Solution

Accepted Solutions
MVP

## Re: set analysis

Perhaps

sum( {\$<MonthName = {"\$(=Month(Today()))"}, system = {Y,X}>} [QUANT]) / 1000

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
4 Replies
Esteemed Contributor

## Re: set analysis

Hi,

to replace May with the current month, you can use an expression within your set_expression.

The syntax is >> {"\$(=Month(Today()))"} <<

<=> Check that in a textbox on the GUI first to make sure that Month(Today()) really does return the name of the month and not just a numeric value.

HTH

MVP

## Re: set analysis

Perhaps

sum( {\$<MonthName = {"\$(=Month(Today()))"}, system = {Y,X}>} [QUANT]) / 1000

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
MVP

## Re: set analysis

Month(Today())) will return a dual with text of the month name and numeric value of the month number.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
New Contributor II

thank you

It worked!