topic Re: define a variable containing from January to current month in QlikView

define a variable containing from January to current month

Mon, 02 Nov 2015 05:18:19 GMT

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 — Mon, 02 Nov 2015 10:17:51 GMT

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()))"}>}

Tue, 03 Nov 2015 01:32:19 GMT

Thanks a lot!