topic Re: set analysis in QlikView

set analysis

Anonymous — Wed, 27 May 2015 11:09:35 GMT

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!

datanibbler — Wed, 27 May 2015 11:28:04 GMT

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

jonathandienst — Wed, 27 May 2015 11:28:58 GMT

Perhaps

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

jonathandienst — Wed, 27 May 2015 11:30:17 GMT

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

Anonymous — Wed, 27 May 2015 11:33:14 GMT

thank you

It worked!