} M...">

Using Variables in Set Analysis Expressoin

I use the following typeset analysis and it cannot return data.

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

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

I tried using a variable with a fixed value. in this case it works fine. see expression below.

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

where vMonth = 4

The variable "vFromDate" takes its value from the calendar extension. and the Minutes field 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,];

If the variable has a simple value, it works, but when the variable has an expression, it does not work.

Please note: I tried to apply the answers in this Question ( QlikView - Use a variable in an expression for analysis) , but, unfortunately, this did not work.

Thanks in advance.

+2
source share
1

, . :

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

+2

All Articles