Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Variable for Month

Hello everyone,

please help to explain the case below. Thanks in advance.

For variable V_MAXMONTH,  We define Let V_MAXMONTH=Month(TODAY()) in data load, my confuse was that  we  cant calculte $(V_MAXMONTH) in TEXT box, and also how to use the month variable in set analysis. Thanks in advance.


Best Regards,

Haifeng

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

try as below:

Let V_MAXMONTH = Month(TODAY());


in your textbox use only the variable name without $ expansion.


set analysis example:

sum( {< your_month_field = {"$(V_MAXMONTH)"} >} your_measure )


I hope this helps.

View solution in original post

3 Replies
Contributor III
Contributor III

One workaround is to create the variable in the Variables section in the Edit Sheet.

Highlighted
Creator III
Creator III

Try like below.

in script

Let vMaxMonth = Month(Today());

Expresion

=vMaxMonth

Highlighted
Partner
Partner

try as below:

Let V_MAXMONTH = Month(TODAY());


in your textbox use only the variable name without $ expansion.


set analysis example:

sum( {< your_month_field = {"$(V_MAXMONTH)"} >} your_measure )


I hope this helps.

View solution in original post