Set Analysis with a Variable

Tue, 24 May 2016 10:47:02 GMT

Hello,

I am using the following set analysis and it fails to return the data.

=Only({1<Month={"$(vMonthNr)"}>} Minutes)

Where: vMonthNr = Month('$(vFromDate)')

I have tried to use a variable which has fixed value. in this case, It works perfectly. please see the expression bellow.

=Only({1<Month={"$(vMonth)"}>} Minutes)

where vMonth = 4

The variable "vFromDate" takes its value from a calendar extension. and the field Minutes comes from this Data.

[Table1]:

LOAD * inline ["Month", "Minutes"

1, 12000,

2, 12600,

3, 12600,

4, 12600,

5, 12000,

6, 13200,

7, 12600,

8, 13800,

9, 13200,

10, 12000,

11, 13200,

12, 12600,];

When the variable has a plain value it works but when the variable has an expression it does not works.

Thanks in advance.

Re: Set Analysis with a Variable

swuehl — Tue, 24 May 2016 12:15:22 GMT

Try

vMonthNr = Num(Month('$(vFromDate)'))

and take care that the variable definition shows a leading equal sign in front of the Num().

Tue, 24 May 2016 12:36:21 GMT

Thanks a lot Stefan. it works pretty correct.