Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
ronitfromvgold
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
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
datanibbler
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
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
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
ronitfromvgold
New Contributor II

Re: set analysis

thank you

It worked!

Community Browser