define a variable containing from January to current month

[#1]

hi,guys!

I need some help with qlikview.

I want to define a variable aggregating the months from January to current month.

how should I write the expression

thanks

[jonathandienst · Accepted solution]

You need to be more specific. A variable cannot contain multiple values (January to current month).

If you want a set expression that spans the month range, then depending on your data model you could use a set expression something like:

     {<Month = {">=$(=Month(YearStart(Today()))) <=$(=Month(Today()))"}>}

[#3]

Thanks a lot!